sql月份汇总查询语句
2020-01-11 20:58

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 [sql月份汇总查询语句。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