本文主要是介绍SQL分组--按天查询、按小时查询数据，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
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");查询结果
这篇关于SQL分组--按天查询、按小时查询数据的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
