select m.id name, IFNULL(b,0) value from
(
select 1 as id union select 2 union select 3 union select 4 union select 5 union select 6
union select 7 union select 8 union select 9 union select 10 union select 11 union select 12
) m
left join
(select month(not2) a,count(id) b from enterprise GROUP BY month(not2)) n
on m.id = n.a
![[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-0V9ws790-1617762984797)(https://imgblog.csdnimg.cn/20210407103537141.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMDgwMDY3,size_16,color_FFFFFF,t_70)]](https://i-blog.csdnimg.cn/blog_migrate/9ae78e9ec7b95fd1c98ce9b7b004ac3b.png)
445
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
