题目:
题目链接: https://leetcode-cn.com/problems/rising-temperature/
解题思路:
datediff库函数的使用
SQL:
select a.id from Weather a, Weather b
where a.Temperature > b.Temperature and datediff(a.recorddate, b.recorddate) = 1
题目链接: https://leetcode-cn.com/problems/rising-temperature/
datediff库函数的使用
select a.id from Weather a, Weather b
where a.Temperature > b.Temperature and datediff(a.recorddate, b.recorddate) = 1