sql按月份统计每个月的总数

sql按月份统计每个月的总数

由于碰到很多次这种需求了 特别是前端需要做一些折线图的数据时候 就需要每个月的统计数据
特意写个sql 记录下

SELECT yue.m as mon,IFNULL(a.sum,0) as sellValue
FROM
(
SELECT 1 AS m
UNION ALL
SELECT 2
UNION ALL
SELECT 3
UNION ALL
SELECT 4
UNION ALL
SELECT 5
UNION ALL
SELECT 6
UNION ALL
SELECT 7
UNION ALL
SELECT 8
UNION ALL
SELECT 9
UNION ALL
SELECT 10
UNION ALL
SELECT 11
UNION ALL
SELECT 12
) yue LEFT JOIN (SELECT MONTH(sell_inventory_create_time) AS m,sum(sell_inventory_money) AS sum FROM sell_inventory  --you tableWHERE YEAR(sell_inventory_create_time)=2021  
GROUP BY MONTH(sell_inventory_create_time) ) a ON yue.m=a.m ORDER BY yue.m asc