继续刷LeetCode,第197题,求表中温度上升的序号
分析:
比较表中两者日期相差为一天,并且前一天温度小于后一天温度的序号。
附上代码:
# Write your MySQL query statement below
SELECT w1.Id as Id
FROM Weather w1,Weather w2
WHERE datediff(w1.RecordDate,w2.RecordDate)=1
AND w1.Temperature>w2.Temperature
继续刷LeetCode,第197题,求表中温度上升的序号
分析:
比较表中两者日期相差为一天,并且前一天温度小于后一天温度的序号。
附上代码:
# Write your MySQL query statement below
SELECT w1.Id as Id
FROM Weather w1,Weather w2
WHERE datediff(w1.RecordDate,w2.RecordDate)=1
AND w1.Temperature>w2.Temperature