【MySQL】【leetcode】 Rising Temperature解题报告

来源:互联网 时间:1970-01-01

题目

Given a Weather table, write a SQL query to find all dates’ Ids with higher temperature compared to its previous (yesterday’s) dates.

1 2015-01-01 10 2 2015-01-02 25 3 2015-01-03 20 4 2015-01-04 30
Id(INT) Date(DATE) Temperature(INT)

For example, return the following Ids for the above Weather table:
+—-+
| Id |
+—-+
| 2 |
| 4 |
+—-+
题目来源:https://leetcode.com/problems/rising-temperature/

代码

某一天的温度比前一天的温度高,则找出这一天的ID。MySQL的TO_DAYS(date)函数返回给定日期从年份0开始计算的天数。

# Write your MySQL query statement belowselect wt2.idfrom Weather as wt1, Weather as wt2where TO_DAYS(wt2.Date) - TO_DAYS(wt1.Date) = 1 and wt2.Temperature > wt1.Temperature;


相关阅读:
Top