题目10:MySQL---------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 |+----+
select a.Id from Weather a,Weather bwhere DATEDIFF(a.Date,b.Date)=1and a.Temperature >b.Temperature;





分享给朋友:
您可能感兴趣的文章:
随机阅读: