SELECT w2.Id
FROM Weather w1, Weather w2
WHERE DATEDIFF(w2.RecordDate, w1.RecordDate) = 1
AND w1.Temperature < w2.Temperature
DATEDIFF(w2.RecordDate, w1.RecordDate):前-后的天数差
SELECT w2.Id
FROM Weather w1, Weather w2
WHERE DATEDIFF(w2.RecordDate, w1.RecordDate) = 1
AND w1.Temperature < w2.Temperature
DATEDIFF(w2.RecordDate, w1.RecordDate):前-后的天数差