select stcd ,tm,drp,
sum(drp) over (partition by stcd order by tm range between interval '3' hour preceding and interval '0' hour following ) accp
from st_pptn_r如何将这条语句转成sqlserver2008,求大牛解救!sqlserveroracle
sum(drp) over (partition by stcd order by tm range between interval '3' hour preceding and interval '0' hour following ) accp
from st_pptn_r如何将这条语句转成sqlserver2008,求大牛解救!sqlserveroracle
stcd ,tm,drp,
sum(drp) over (partition by stcd order by tm ) accp
from
st_pptn_r
where
xxxx --这里去填写你的那个条件
试试
select
stcd ,tm,drp,
sum(drp) over (partition by stcd order by tm) accp
from
st_pptn_r
where
datediff(hh,tm,getdate())>=3
按stcd分组order by tm
按tm排序range between interval '3' hour preceding and interval '0' hour following
取当前记录前3个小时到当时记录时间之间的记录