MYSQL根据月份统计数量_mysql 按每个月统计数量

作者：Gausst松鼠会 | 2024-04-15 01:37:09

踩

mysql 按每个月统计数量


select aaa.MONTH as name, 
ifnull(b.count, 0) as value 
from 
( select DATE_FORMAT(CURDATE(), '%m') as MONTH 
union select DATE_FORMAT(CURDATE() - interval 1 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 2 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 3 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 4 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 5 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 6 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 7 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 8 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 9 month, '%m') 
union select DATE_FORMAT(CURDATE() - interval 10 month, '%m') ) aaa 
left join 
( select DATE_FORMAT(f.create_time, '%m') as NAME, count(1) as count from busi_res_carbon f 
where year(f.create_time) = 2023 and is_delete = 0 
group by DATE_FORMAT(f.create_time, '%m') ) b 
on aaa.MONTH = b.NAME 
order by aaa.MONTH

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Gausst松鼠会/article/detail/425139