我的LeetCode代码仓:https://github.com/617076674/LeetCode
原题链接:https://leetcode-cn.com/problems/rising-temperature/description/
题目描述:
知识点:TO_DAYS()函数、DATEDIFF()函数
思路一:TO_DAYS()函数计算时间差
TO_DAYS()函数返回从年份0开始的天数。
在多表连查中多表间用逗号分隔,相当于关键字(INNER) JOIN。
SQL语句:
SELECT
w1.Id
FROM
Weather AS w1, Weather AS w2
WHERE
w1.Temperature > w2.Temperature AND TO_DAYS(w1.RecordDate) - TO_DAYS(w2.Reco