197. Rising Temperature(SQL)

# 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

Previous196. Delete Duplicate Emails（SQL）Next200. Number of Islands

Last updated