您好,group by后面的就是分组的条件,所以您的这个表可以这样写sql
- select 供应商编号,供应商名称,产品编号,产品编号,year(日期) as 日期,
- sum(case when month(日期)=1 then 单价 else 0 end) as "1月份",sum(case when month(日期)=2 then 单价 else 0 end) as "2月份",
- sum(case when month(日期)=3 then 单价 else 0 end) as "3月份",sum(case when month(日期)=4 then 单价 else 0 end) as "4月份",
- sum(case when month(日期)=5 then 单价 else 0 end) as "5月份",sum(case when month(日期)=6 then 单价 else 0 end) as "6月份",
- sum(case when month(日期)=7 then 单价 else 0 end) as "7月份",sum(case when month(日期)=8 then 单价 else 0 end) as "8月份",
- sum(case when month(日期)=9 then 单价 else 0 end) as "9月份",sum(case when month(日期)=10 then 单价 else 0 end) as "10月份",
- sum(case when month(日期)=11 then 单价 else 0 end) as "11月份",sum(case when month(日期)=12 then 单价 else 0 end) as "12月份"
- from A表
- group by 供应商编号,供应商名称,产品编号,产品编号,year(日期)
复制代码
|