dateDiff函数用来判断两个日期的差值
select a.id
From Weather a, Weather b
where dateDiff(a.recordDate, b.recordDate) = 1 and
a.temperature > b.temperature
dateDiff函数用来判断两个日期的差值
select a.id
From Weather a, Weather b
where dateDiff(a.recordDate, b.recordDate) = 1 and
a.temperature > b.temperature