leetcode（197） 上升的温度

方法一：
利用DATE_ADD函数：

# Write your MySQL query statement below
SELECT W2.Id
FROM Weather W1,Weather W2
WHERE W1.Temperature<W2.Temperature AND
      W2.RecordDate=DATE_ADD(W1.RecordDate, interval 1 day)
;

方法二：
DATEDIFF()

# Write your MySQL query statement below
SELECT W1.Id AS Id
FROM Weather W1
JOIN Weather W2 ON DATEDIFF(W1.RecordDate,W2.RecordDate)=1
    AND W1.Temperature>W2.Temperature 
;

# 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 
;