SQL通过分组来计数行
SQL通过分组来计数行
提问于 2016-01-25 13:52:45
我有一张桌子：
A B
---------
1 Date1
1 Date1
1 Date1
1 Date2
2 Date1
3 Date3
4 Date2
4 Date1
1 Date3
SELECT A, count(A) FROM `table` WHERE B BETWEEN 'Date1' AND 'Date2'
GROUP BY A
ORDER BY A当我进行正常查询时：
A B
----------
1 1
1 1
1 1
2 1
3 1
4 1
4 1不需要数多少天？对此有什么简单的查询吗？请帮帮忙
需要以下数据：
A B
----------
1 3
2 1
3 1
4 2回答 2
Stack Overflow用户
回答已采纳
发布于 2016-01-25 14:41:57
解决问题：
SELECT T1.id as id, COUNT(COALESCE(T2.totalcountdepartmentuserwise, 0)) AS totalcountdepartmentuserwise
FROM (
SELECT DISTINCT id FROM users WHERE company_id = 33
) AS T1
LEFT JOIN (
SELECT user_id, COUNT(distinct user_id) AS totalcountdepartmentuserwise FROM userlogs WHERE created_at BETWEEN '2016-01-01' AND '2016-01-25' GROUP BY user_id, DATE(created_at) ORDER BY user_id
) AS T2 ON T2.user_id = t1.id GROUP BY id Stack Overflow用户
发布于 2016-01-25 14:03:08
看来你需要数(不同的B)
SELECT A, count(distinct B)
FROM `table` WHERE B BETWEEN 'Date1' AND 'Date2'
GROUP BY A
ORDER BY A;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/34994290
复制相关文章
相似问题
腾讯云开发者
