197. 上升的温度 + datediff + 日期数据的比较

197. 上升的温度

LeetCode_MySql_197

题目描述

代码实现

# Write your MySQL query statement below
select we1.id Id
from Weather we1, Weather we2
where datediff(we1.recordDate, we2.recordDate) = 1
    and we1.Temperature > we2.Temperature;