Leetcode Problem 197. Rising Temperature
Leetcode Solutions
Finding Dates with Higher Temperatures Compared to Previous Dates
- Perform a self-join on the
Weathertable, aliasing one instance asweatherand the other asw. - Use the
DATEDIFF()function to find pairs of records whereweather.recordDateis exactly one day afterw.recordDate. - Add a condition to the join to only include pairs where
weather.temperatureis greater thanw.temperature. - Select the
idfrom theweathertable for the rows that meet the above conditions. - Return the result, which will be a list of
idvalues corresponding to the dates with higher temperatures compared to the previous day.
erDiagram
Weather {
int id
date recordDate
int temperature
}Finding Dates with Higher Temperatures Using Subquery
Ask Question
Programming Language
Purpose:
image/screenshot of info(optional)
Full Screen
Loading...
Suggested Answer
Answer
Full Screen
Copy Answer Code
Loading...