sql server 中按照周进行汇总

iteye_6233

于 2012-04-22 17:08:00 发布

阅读量348

点赞数

select sum(number) as 销售总额,DATEPART(week,sell_date),convert(varchar(10), dateadd(day,-1,DATEADD(wk,datediff(wk,0,rtrim(datepart(year, sell_date )))+datepart(wk,sell_date )-1,0)) , 20)
from sell_info where 1=1 and sell_date >= '2011-01-01' and sell_date <= '2011-03-01' 
group by DATEPART(week,sell_date), convert(varchar(10), dateadd(day,-1,DATEADD(wk,datediff(wk,0,rtrim(datepart(year, sell_date )))+datepart(wk,sell_date )-1,0)) , 20)