For example, return the following Ids for the above Weather table:
1 2 3 4 5 6
+----+ | Id | +----+ | 2 | | 4 | +----+
1 2
# Write your MySQL query statement below select w1.Id Id from Weather w1, Weather w2 where (w1.RecordDate)= to_days(w2.RecordDate) + 1 and w1.Temperature > w2.Temperature
近期评论