One method is: select s.* from sensor s where t > 4 and not exists (select 1 from sensor s2 where s2.datetime >= s.datetime and s2.datetime ...
確定! 回上一頁