首页 >数据库 >mysql教程 >sql月份汇总查询语句

sql月份汇总查询语句

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原创
2016-06-07 17:47:341391浏览

sql月份汇总查询语句

select '铅笔' as [月份],
sum(case month(日期) when 1 then 铅笔 else 0 end) as [1月],
sum(case month(日期) when 2 then 铅笔 else 0 end) as [2月],
sum(case month(日期) when 3 then 铅笔 else 0 end) as [3月],
sum(case month(日期) when 4 then 铅笔 else 0 end) as [4月],
sum(case month(日期) when 5 then 铅笔 else 0 end) as [5月],
sum(铅笔) as 总价
from table

union all

select '钢笔' as [月份],
sum(case month(日期) when 1 then 钢笔 else 0 end) as [1月],
sum(case month(日期) when 2 then 钢笔 else 0 end) as [2月],
sum(case month(日期) when 3 then 钢笔 else 0 end) as [3月],
sum(case month(日期) when 4 then 钢笔 else 0 end) as [4月],
sum(case month(日期) when 5 then 钢笔 else 0 end) as [5月],
sum(钢笔) as 总价
from table


结果

 铅笔 1月 2月 3月 4月 5月 总价
  铅笔 200 500 600 700 500 2500
  钢笔 200 300 250 400 300 1450
  毛笔 300 400 500 300 600 2100
  总价 700 1200 1350 1400 1400 6050

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn