LeetCode - 197. Rising Temperature (MySQL)

Easy, SQL - 이전 row와 비교하기

RunTime : 408 ms

문제

Write a solution to find all dates Id with higher temperatures compared to its previous dates (yesterday).

Return the result table in any order.

The result format is in the following example.

풀이

• 이전 날짜의 데이터 값과 비교하는 경우에는 DATEDIFF를 사용할 수 있다.

SELECT W2.ID
FROM Weather as w1 join Weather as w2
ON DATEDIFF(w2.recordDate, w1.recordDate) = 1
WHERE w1.temperature < w2.temperature;