[LeetCode]Rising Temperature,解题报告

目录

---

题目

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

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

For example, return the following Ids for the above Weather table:

Id 2 4

思路

这是一道很简单的sql题目，考察的是数据库表联接知识。可以参考我之前的一篇博客：数据库表连接

同时，介绍一个Mysql的函数：

TO_DAYS(date):给定一个日期data，返回从年份0开始的天数

---

AC SQL

select w1.Id from Weather as w1 inner join Weather as w2 on TO_DAYS(w1.Date) = TO_DAYS(w2.Date) + 1 and w1.Temperature > w2.Temperature;