select max(时间) ,sum(人数) ,max(人数) ,min(人数),avg(人数)
from table
where 时间between convert(varchar(14) ,时间,120) + '00:00' and convert(varchar(14) ,时间,120) + '15:00'
union all
select max(时间) ,sum(人数) ,max(人数) ,min(人数),avg(人数)
from table
where 时间between convert(varchar(14) ,时间,120) + '15:00' and convert(varchar(14) ,时间,120) + '30:00'
union all
select max(时间) ,sum(人数) ,max(人数) ,min(人数),avg(人数)
from table
where 时间between convert(varchar(14) ,时间,120) + '30:00' and convert(varchar(14) ,时间,120) + '45:00'
union all
select max(时间) ,sum(人数) ,max(人数) ,min(人数),avg(人数)
from table
where 时间between convert(varchar(14) ,时间,120) + '45:00' and dateadd(hh,1,convert(varchar(14) ,时间,120) + '00:00')
from table
where 时间between convert(varchar(14) ,时间,120) + '00:00' and convert(varchar(14) ,时间,120) + '15:00'
union all
select max(时间) ,sum(人数) ,max(人数) ,min(人数),avg(人数)
from table
where 时间between convert(varchar(14) ,时间,120) + '15:00' and convert(varchar(14) ,时间,120) + '30:00'
union all
select max(时间) ,sum(人数) ,max(人数) ,min(人数),avg(人数)
from table
where 时间between convert(varchar(14) ,时间,120) + '30:00' and convert(varchar(14) ,时间,120) + '45:00'
union all
select max(时间) ,sum(人数) ,max(人数) ,min(人数),avg(人数)
from table
where 时间between convert(varchar(14) ,时间,120) + '45:00' and dateadd(hh,1,convert(varchar(14) ,时间,120) + '00:00')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货