我正在尝试对名为"的SQL表中的行进行计数;报告";,按";工作";为0/1/2。
目前,我有一个SQL查询,它可以给我三行,每行都有一个计数器,表示有多少行";工作";作为0/1/2。
SELECT `working`, COUNT(`working`) AS `total` FROM `reports`
WHERE `appid` = 379720
GROUP BY `working`
ORDER BY `report_id` DESC LIMIT 30
因此,它目前(根据SQL正确地(给了我类似的东西:
工作 | |
---|---|
0 | 12 |
1 | 34 |
2 | 18 |
您似乎想要count(distinct)
:
SELECT `working`, COUNT(DISTINCT author_id) AS `total`
FROM `reports`
WHERE `appid` = 379720
GROUP BY `working`
ORDER BY `report_id` DESC