22,210
社区成员
发帖
与我相关
我的任务
分享
select sum(数据流量) from TB
group by
convert(varchar(13),时间字段,120)+
Cast((case when datepart(n,时间字段)<=30 then 1 else 2 end) as varchar(5))
select sum(数据流量) from TB
group by
Cast(datepart(hh,时间) as varchar(5)) +
Cast((case when datepart(n,时间)<=30 then 1 else 2 end) as varchar(5))
Create View v_TB
as
SELECT DATEPART(dd,时间字段) AS 日期,DATEPART(hh,时间字段) AS 小时,
SUM(CASE WHEN DATEPART(mi,时间字段) <30 THEN 流量数 ELSE 0 END ) AS [00-30],
SUM(CASE WHEN DATEPART(mi,时间字段) >30 THEN 流量数 ELSE 0 END ) AS [30-59],
from TB
group BY DATEPART(dd,时间字段),DATEPART(hh,时间字段)
try