这是您想要的吗?
select *
from (select a.*,
lag(sdt) over (partition by id order by sdt) as prevsdt,
lead(sdt) over (partition by id order by sdt) as nextsdt
from table_a a
) a
where sdt - prevsdt <= 1/(24*60) or
nextsdt - sdt <= 1/(24*60);
它在SQL Fiddle上产生所需的输出。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句