如何按月显示零值数据

Question

我有一个"MySQL Query“，一年内有一个数据项的表。我想根据月份分组来显示。

SELECT MONTHNAME(create_date) AS month, COUNT(*) AS cplan FROM nota_jual GROUP BY month

​

​

我希望每个月显示的数据都包含值为0的项目。

month       cplan
January     3       
February    2       
March       0       
April       0       
May         0       
June        0       
July        8       
August      8       
September   6       
October     3       
November    5       
December    3       

有人能帮我/answer一下吗？(谢谢)

Answer 1

看看这个

SELECT date_format(tn.create_date,'%m') as Month, count(*) as cpplan
FROM nota_jual tn
GROUP BY Month
ORDER by Month;