select date_table.lastDays as monthValue,IFNULL(temp.count, 0 ) as eventCount from ( SELE
select date_table.lastDays as monthValue,IFNULL(temp.count, 0 ) as eventCount from ( SELECT date_fORMat(@lastDay := last_day( date_add(@lastDay,interval 1 month ) ) ,'%Y-%m' ) lastDays from (SELECT @lastDay := date_add(curdate(),interval -6 month) from Mysql.help_topic limit 6) a ) date_table left join( select DATE_FORMAT(sc.时间,'%Y-%m') as monthValue, count(sc.统计参数) as count from 表名 sc GROUP BY DATE_FORMAT(sc.时间,'%Y-%m') )temp on temp.monthValue = date_table.lastDays
结果:
来源地址:https://blog.csdn.net/weixin_47962813/article/details/128083703
--结束END--
本文标题: mysql 查询最近6个月的数据(每个月的数据,没有数据的为0)
本文链接: https://www.lsjlt.com/news/398547.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-28
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0