SQL分组--按天查询、按小时查询数据

最新推荐文章于 2024-07-24 17:08:13 发布

万物可测

最新推荐文章于 2024-07-24 17:08:13 发布

阅读量7k

点赞数 4

分类专栏： SQL 文章标签： sql

本文链接：https://blog.csdn.net/qq_38915739/article/details/125302930

版权

SQL 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

log:

背景

统计数据，需要统计每天的数据量，然后再统计每个小时的数据量

SQL

按小时统计数量

---按小时统计数据量
SELECT count(id)as "会员数", DATE_FORMAT(created,"%Y-%m-%d %H:00:00") as "时间" from t_m_plat_member 
 where card_plan_id =1000190001 and bind =1 and created BETWEEN "2022-06-01 00:00:00" and "2022-06-14 23:59:59"
 GROUP BY DATE_FORMAT(created,"%Y-%m-%d %H:00:00");

查询结果

按天统计数量


---按天统计数据量
SELECT count(id)as "会员数", DATE_FORMAT(created,"%Y-%m-%d") as "时间" from t_m_plat_member 
 where card_plan_id =1000190001 and bind =1 and created BETWEEN "2022-06-01 00:00:00" and "2022-06-14 23:59:59"
 GROUP BY DATE_FORMAT(created,"%Y-%m-%d0");

查询结果