select count (*) as ss,DATEPART (Hour,[time]) as h,iparea from click where [time] between '2007-5-1' and '2007-5-30' group by iparea,DATEPART (Week,[time]) order by iparea,h
select data from table1 where datediff(week,datecolumn,getdate())<=4 group by datepart(week,[datecolumn]),data
select count (*) as ss,DATEPART (Hour,[time]) as h,iparea from click where [time] between '2007-5-1' and '2007-5-30' group by iparea,DATEPART (Week,[time]) order by iparea,h修正select count (*) as ss,DATEPART (Week,[time]) as h,iparea from click where [time] between '2007-5-1' and '2007-5-30' group by iparea,DATEPART (Week,[time]) order by iparea,h
select count (*) as ss,DATEPART (Hour,[time]) as h,iparea from click where [time] between '2007-5-1' and '2007-5-30' group by iparea,DATEPART (Week,[time]) order by iparea,h修正select count (*) as ss,DATEPART (Week,[time]) as h,iparea from click where [time] between '2007-5-1' and '2007-5-30' group by iparea,DATEPART (Week,[time]) order by iparea,h
oracle 用sysdate - 7即可