SQL查询所选数据中相邻两行的时间相减

with t as (
select OID,time,ROW_NUMBER() over (order by OID) rn
from shengchan t
where time> '2016-08-25'
and deviceID= 18

)
select sc.OID,sc.time,t.OID,t.time,DATEDIFF(SECOND,sc.time,t.time)
from shengchan sc
left join t on t.rn = (select rn + 1 from t where t.OID = sc.OID)
where time> '2016-08-25'
and deviceID= 18
order by sc.OID desc