LeetCode Rising Temperature,leetcode

來源:互聯網
上載者:User

LeetCode Rising Temperature,leetcode

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 b.id as Id from Weather a, Weather b where to_days(a.date) = to_days(b.date) - 1 and a.temperature < b.temperature

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.