select saledate as 销售月份,
bookid as 书籍编号,
bookname as 书籍名称,
sum(case when [WeekDay]='星期一' then quantity else 0 end) as 星期一,
sum(case when [WeekDay]='星期二' then quantity else 0 end) as 星期二,
sum(case when [WeekDay]='星期三' then quantity else 0 end) as 星期三,
sum(case when [WeekDay]='星期四' then quantity else 0 end) as 星期四,
sum(case when [WeekDay]='星期五' then quantity else 0 end) as 星期五,
sum(case when [WeekDay]='星期六' then quantity else 0 end) as 星期六,
sum(case when [WeekDay]='星期日' then quantity else 0 end) as 星期日
from tb_Book
group by saledate , bookid , bookname
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货