问查询Count on coulmns by condition with Group BY
EN

Stack Overflow用户

提问于 2012-01-07 18:58:23

回答 3查看 103关注 0票数 0

表结构

id(int)
dated_on(datetime)
(many_more)

包含数千个按id分组的数据的表。

I want result as id, count of that id, 
also count of id having date difference is week.(i.e. count of data last week)

发布于 2012-01-07 20:19:39

我也得到了解决方案：

SELECT id, count(id) as counter, 
COUNT(CASE WHEN DATEDIFF( CURDATE(), dated_on ) < 7 THEN 1 ELSE NULL END) AS latest_count
FROM my_table
GROUP BY id

票数 0

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/8769142

复制

相似问题

问查询Count on coulmns by condition with Group BYEN