SQL每日一题(20210602)
SQL每日一题(20220111)
SQL每日一题(20220613)
SQL每日一题(20220722)
select * from T1218 a
inner join T1218 b
on DATE_ADD(a.REDATE,INTERVAL 1 day) = b.REDATE
and a.TEMP < b.TEMP
select id
from (select id, TEMP, lag(TEMP) over (ORDER BY REDATE) as TEMP2 from t1218) a
where TEMP > TEMP2