select
[name],
[周记录] = sum(case when datediff(wk,[date],'2005-06-01')=0 then [count] else 0 end),
[月记录] = sum(case when datediff(mm,[date],'2005-06-01')=0 then [count] else 0 end),
[年记录] = sum(case when datediff(yy,[date],'2005-06-01')=0 then [count] else 0 end),
from
AAA
group by
[name]
order by
[name]
[name],
[周记录] = sum(case when datediff(wk,[date],'2005-06-01')=0 then [count] else 0 end),
[月记录] = sum(case when datediff(mm,[date],'2005-06-01')=0 then [count] else 0 end),
[年记录] = sum(case when datediff(yy,[date],'2005-06-01')=0 then [count] else 0 end),
from
AAA
group by
[name]
order by
[name]
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货