[LeetCode] Database | 197. Rising Temperature

Problem

---

Example

---

 

Thinking

---

이번에 배운 함수가 있다 DATEDIFF

 

DATEDIFF(date1, date2) 는 곧 date1 - date2 이다

위의 문제에서는 다음날의 데이터와 비교를 해야하는 것이니 하루 차이이다.

그럼 DATEDIFF(today.recordDate, yesterday.recordDate) = 1 이라고 적어줄 수 있다. 

 

Solve

---

제출 답안

 

SELECT today.id
    FROM Weather AS today
    JOIN Weather AS yesterday ON DATEDIFF(today.recordDate, yesterday.recordDate) = 1
    WHERE today.temperature > yesterday.temperature

---

---

 

https://leetcode.com/problems/rising-temperature

Rising Temperature - LeetCode