php家庭财务管理收支表

[登峰造极境]

那个按月分的数据统计求告知方法

[蜗牛慢慢向上爬]

SELECT flowcode,
SUM(CASE WHEN MONTH(create_time) =1 THEN 1 ELSE 0 END) 一月,
SUM(CASE WHEN MONTH(create_time) =2 THEN 1 ELSE 0 END) 二月,
SUM(CASE WHEN MONTH(create_time) =3 THEN 1 ELSE 0 END) 三月,
SUM(CASE WHEN MONTH(create_time) =4 THEN 1 ELSE 0 END) 四月,
SUM(CASE WHEN MONTH(create_time) =5 THEN 1 ELSE 0 END) 五月,
SUM(CASE WHEN MONTH(create_time) =6 THEN 1 ELSE 0 END) 六月,
SUM(CASE WHEN MONTH(create_time) =7 THEN 1 ELSE 0 END) 七月,
SUM(CASE WHEN MONTH(create_time) =8 THEN 1 ELSE 0 END) 八月,
SUM(CASE WHEN MONTH(create_time) =9 THEN 1 ELSE 0 END) 九月,
SUM(CASE WHEN MONTH(create_time) =10 THEN 1 ELSE 0 END) 十月,
SUM(CASE WHEN MONTH(create_time) =11 THEN 1 ELSE 0 END) 十一月,
SUM(CASE WHEN MONTH(create_time) =12 THEN 1 ELSE 0 END) 十二月,
COUNT(flowcode) 合计
FROM demo003
GROUP BY flowcode