Leetcode Rising Temperature

题目地址:https://leetcode.com/problems/rising-temperature/

题目解答:

# Write your MySQL query statement below
select w1.Id from Weather w1 inner join
Weather w2 on TO_DAYS(w1.Date) = TO_DAYS(w2.Date)+1
and w1.Temperature>w2.Temperature;

 

posted @ 2015-04-08 11:48  buptubuntu  阅读(104)  评论(0)    收藏  举报