MySql按周，按月，按日分组统计数据

长春小霸王

于 2022-03-10 22:00:44 发布

阅读量571

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/jbossjf/article/details/123412698

mysql 专栏收录该内容

16 篇文章

订阅专栏

本文介绍了如何使用SQL查询从o_finance_detail表中按天、月、年和周统计1000号组织的财务金额总和，适合分析组织的财务趋势。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<!-- 按日查询 -->  
SELECT DATE_FORMAT(created_date,'%Y-%m-%d') as time,sum(money) money FROM o_finance_detail where org_id = 1000  GROUP BY  time  
<!-- 按月查询 -->  
SELECT DATE_FORMAT(created_date,'%Y-%m') as time,sum(money)  money FROM o_finance_detail where org_id = 1000  GROUP BY  time  
<!-- 按年查询 -->  
SELECT DATE_FORMAT(created_date,'%Y') as time,sum(money)  money FROM o_finance_detail where org_id = 1000  GROUP BY  time   
<!-- 按周查询 -->  
SELECT DATE_FORMAT(created_date,'%Y-%u') as time,sum(money)  money FROM o_finance_detail where org_id = 1000  GROUP BY  time

关注博主即可阅读全文