按照周次分组获得各周的总数 select datepart(wk,date_field),sum(data_Field) from table_Pqs group by datepart(wk,date_field)
如果知道一个日期,那么先获得当前周 declare @zc_Pqs int select @zc_Pqs=datepart(wk,'19760310')select @zc_Pqs,sum(data_Field) from table_Pqs where datepart(wk,date_field)=@zc_Pqs即可
select (@@datefirst+datepart(dw,getdate())-1)%7--把getdate()换为时间列就行了
计算0为星期日
(@@datefirst+datepart(dw,getdate())-1)%7
select sum(col1) 汇总,datepart(wk,时间字段) 第几周
from 表
group by datepart(wk,时间字段)
--------------
rookie_one(流氓会武术,谁都挡不住) 你的方法也可以
select datepart(wk,date_field),sum(data_Field) from table_Pqs
group by datepart(wk,date_field)
declare @zc_Pqs int
select @zc_Pqs=datepart(wk,'19760310')select @zc_Pqs,sum(data_Field) from table_Pqs where datepart(wk,date_field)=@zc_Pqs即可