select w2.Id
from
Weather w1, Weather w2
where w2.Temperature > w1.Temperature AND DATEDIFF(w2.RecordDate, w1.RecordDate) = 1
select w2.Id
from
Weather w1, Weather w2
where w2.Temperature > w1.Temperature AND DATEDIFF(w2.RecordDate, w1.RecordDate) = 1