select a.*
from oradata a
left join (select id,detecttime from oradata where id=1)b
on datediff(second,b.detectime,a.decttime) between 0 and 10
from oradata a
left join (select id,detecttime from oradata where id=1)b
on datediff(second,b.detectime,a.decttime) between 0 and 10
id = 1的记录的detectTime的值相差在10秒内。请问这个SQL语句如何写啊?
select * from
(select * from oraData where detectTime is null) A,
(select * from oraData where id=1) B
where datediff(ss,A.detectTime ,B.detectTime )-10=0 or
datediff(ss,A.detectTime ,B.detectTime )+10 =0