34,838
社区成员




select datepart(wk,datecol),sum(..........)
from t
where datecol between .... and ....
grtoup by datepart(wk,datecol)
select convert(varchar(7),max(dt),120),count(1) from # group by case when day(dt)<26 then convert(varchar(7),dt,120) else convert(varchar(7),dateadd(month,1,dt),120) end
------- -----------
2007-01 3
2007-02 3
(2 行受影响)
create table # (id int identity(1,1),dt datetime)
insert into # values('2006-12-26')
insert into # values('2007-01-01')
insert into # values('2007-01-22')
insert into # values('2007-01-28')
insert into # values('2007-02-01')
insert into # values('2007-02-11')
select count(1) from # group by case when day(dt)<26 then convert(varchar(7),dt,120) else convert(varchar(7),dateadd(month,1,dt),120) end
-----------
3
3
group by case when day(时间)<26 then convert(varchar(7),时间,120) else convert(varchar(7),dateadd(month,1,时间),120) end
group by case when day(出生年月)<26 then convert(varchar(7),时间,120) else convert(varchar(7),dateadd(month,1,时间),120) end