write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates. +---------+------------------+------------------+ | Id(INT) | RecordDate(DATE) | Temperature(INT) | +---------+------------------+------------------+ | 1 | 2015-01-01 | 10 | | 2 | 2015-01-02 | 25 | | 3 | 2015-01-03 | 20 | | 4 | 2015-01-04 | 30 | +---------+------------------+------------------+
return the following Ids +----+ | Id | +----+ | 2 | | 4 | +----+
select w1.id from weather w1,weather w2 where to_days(w1.recorddate)
-to_days(w2.recorddate)=1 and w1.temperature>w2.temperature;
利用to_days,将日期之间变得可以比较,即2001-10-01 - 2001-09-30 =1
即,日期被当成整数进行比较了!