Solving Rising Temperature in SQL. Please try yourself first to solve the problem and submit your implementation to LeetCode before looking into solution.

Problem Description

Table: Weather

+---------------+---------+
| Column Name | Type |
+---------------+---------+
| id | int |
| recordDate | date |
| temperature | int |
+---------------+---------+

id is the primary key for this table. This table contains information about the temperature in a certain day.

Write an SQL query to find all dates' id with higher temperature compared to its previous dates (yesterday).

Return the result table in any order. The query result format is in the following example:

Weather Table

+----+------------+-------------+
| id | recordDate | Temperature |
+----+------------+-------------+
| 1 | 2015-01-01 | 10 |
| 2 | 2015-01-02 | 25 |
| 3 | 2015-01-03 | 20 |
| 4 | 2015-01-04 | 30 |
+----+------------+-------------+

Result table:

+----+
| id |
+----+
| 2 |
| 4 |
+----+

  • In 2015-01-02, temperature was higher than the previous day (10 -> 25).
  • In 2015-01-04, temperature was higher than the previous day (30 -> 20).

See the full details of the problem Rising Temperature at LeetCode

Originally posted at: @github.com/ignacio-chiazzo/Algorithms-Leetcode-Javascript