SQL/SQL 문제

[Leetcode] 197. Rising Temperature

Lim Seung Hyun 2022. 4. 18. 22:38

문제 출처

 

Rising Temperature - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

 

나의 풀이(MySQL)

SELECT w2.id
FROM Weather AS w1
JOIN Weather As w2 
ON DATE(w1.recordDate) = DATE_SUB(w2.recordDate, INTERVAL 1 DAY)
WHERE w1.temperature < w2.temperature
728x90
저작자표시