1 题目描述
2 解题思路
注意一个函数 DATEDIFF(x,y) 表示y和x天数的差距
SELECT W2.id
FROM Weather W1, Weather W2
WHERE DATEDIFF(W2.RecordDate, W1.RecordDate) = 1
AND W1.Temperature<W2.Temperature
注意一个函数 DATEDIFF(x,y) 表示y和x天数的差距
SELECT W2.id
FROM Weather W1, Weather W2
WHERE DATEDIFF(W2.RecordDate, W1.RecordDate) = 1
AND W1.Temperature<W2.Temperature