代码语言:javascript复制
select w1.id
from weather w1
join weather w2 on
datediff(w1.recorddate,w2.recorddate)=1
and w1.temperature>w2.temperature