leetcode 197. Rising Temperature

查询今天比前一天温度低的Id。

select a.Id from Weather a, Weather b where TO_DAYS(a.Date) = TO_DAYS(b.Date) + 1 and a.Temperature > b.Temperature;

 

posted on 2018-01-31 19:49  willaty  阅读(107)  评论(0编辑  收藏  举报

导航