求条SQL语句？

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