臭氧的滑动平均
select FID,version,fsiteid,fDATETIME, case when (count(fO3) OVER (partition by fsiteid order by fDATETIME RANGE interval ‘7‘ hour preceding ))>5 then (avg(fO3) OVER (partition by fsiteid order by fDATETIME RANGE interval ‘7‘ hour preceding )) else null end O3_8H from DQ_hour_data_tb;
原文：http://www.cnblogs.com/kingxiaozi/p/4493602.html