# Easy
# Write your MySQL query statement below select w1.Id from Weather w1, Weather w2 where datediff(w1.recordDate, w2.recordDate) = 1 and w1.Temperature > w2.Temperature
时间差必须要用datediff(date1, date2)来判断,此方法表明date1-date2 = 1
date1-date2 = 1
Last updated 4 years ago
Was this helpful?