leetcode 197. 上升的温度197. 上升的温度 - 力扣（LeetCode） datediff函数, 可以计

datediff函数, 可以计算两个日期之间的差

DATEDIFF('2007-12-31','2007-12-30');   # 1
DATEDIFF('2010-12-30','2010-12-31');   # -1
-- 注意是拿参数1减去参数2得到的日期差

所以本题是自查询 + datediff函数

select
    d2.id as Id
from
    Weather as d1,
    Weather as d2
where
    d2.temperature > d1.temperature
    and
    datediff(d2.recordDate, d1.recordDate) = 1;