For example, return the following Ids for the above Weather table:
1 2 3 4 5 6
+----+ | Id | +----+ | 2 | | 4 | +----+
分析
找出时间相隔一天,后一天温度比前一天温度要高的 Id
解决方案(MySQL)
1 2 3 4 5
# Write your MySQL query statement below SELECT t1.Id FROM Weather t1, Weather t2 WHERE TO_DAYS(t1.Date)-TO_DAYS(t2.Date)=1 AND t1.Temperature > t2.Temperature