实现1-12月份查询统计代码,MYSQL代码库,德仔网

代码语言

代码分类

【MYSQL】实现1-12月份查询统计

作者:奕男 / 发布于2018/6/13/ 1487

-- 统计方法二
select 
sum(case month(lesson.time) when '1' then 1 else 0 end) as 一月份,
sum(case month(lesson.time) when '2' then 1 else 0 end) as 二月份,
sum(case month(lesson.time) when '3' then 1 else 0 end) as 三月份,
sum(case month(lesson.time) when '4' then 1 else 0 end) as 四月份,
sum(case month(lesson.time) when '5' then 1 else 0 end) as 五月份,
sum(case month(lesson.time) when '6' then 1 else 0 end) as 六月份,
sum(case month(lesson.time) when '7' then 1 else 0 end) as 七月份,
sum(case month(lesson.time) when '8' then 1 else 0 end) as 八月份,
sum(case month(lesson.time) when '9' then 1 else 0 end) as 九月份,
sum(case month(lesson.time) when '10' then 1 else 0 end) as 十月份,
sum(case month(lesson.time) when '11' then 1 else 0 end) as 十一月份,
sum(case month(lesson.time) when '12' then 1 else 0 end) as 十二月份
from lesson
where year(lesson.time)='2016';

试试其它关键字

同语言下

可能有用的

奕男贡献的其它代码(13)