select (datepart(minute,min([time]))/5+1)*5 as time,sum(car_move_num) as car_num from t1 group by datepart(minute,[time])/5不过空的时间没有考虑。
忘了加查询条件 select (datepart(minute,min([time]))/5+1)*5 as time,sum(car_move_num) as car_num from t1 where [time] >= '2001-3-12 3:01:00' and [time] <'2001-3-12 4:01:00' group by datepart(minute,[time])/5
select (datepart(minute,min([time]))/5+1)*5 as time,sum(car_move_num) as car_num from t1
where [time] >= '2001-3-12 3:01:00' and [time] <'2001-3-12 4:01:00'
group by datepart(minute,[time])/5