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;
【本文章出自博客园willaty,转载请注明作者出处,误差欢迎指出~】
查询今天比前一天温度低的Id。
select a.Id from Weather a, Weather b where TO_DAYS(a.Date) = TO_DAYS(b.Date) + 1 and a.Temperature > b.Temperature;