_197. Rising Temperature.md

197. Rising Temperature

All prompts are owned by LeetCode. To view the prompt, click the title link above.

Back to top

---

First completed : May 22, 2024

Last updated : July 01, 2024

---

Related Topics : Database

Acceptance Rate : 49.48 %

---

Solutions

• e197.sql

SQL

e197.sql

SELECT 
    w1.id
FROM 
    Weather w1 JOIN Weather w2 ON DATEDIFF(w1.recordDate, w2.recordDate) = 1
WHERE 
    w1.temperature > w2.temperature;