select a.id from Weather a inner join Weather b on datediff(a.recordDate,b.recordDate)=1 and a.Temperature >b.Temperature;
datediff(a.recordDate,b.recordDate):返回两个日期的差值
select a.id from Weather a inner join Weather b on a.recordDate=ADDDATE(b.recordDate, 1) and a.Temperature >b.Temperature;
ADDDATE(b.recordDate, 1):返回b.recordDate+1天的日期
主要是两个函数的用法,日期是否刚好是隔一天