法一:
select a.id as Id
from Weather a,Weather b
where DATEDIFF(a.recordDate,b.recordDate)=1
and a.Temperature>b.Temperature;
#MySQL 使用 DATEDIFF 来返回两个日期间的差值
法二:
select a.id as Id
from Weather a
join Weather b
on DATEDIFF(a.recordDate,b.recordDate)=1
and a.Temperature>b.Temperature;
#inner join 内连接或等值连接: 获取两个表中字段匹配关系的记录,可以忽略inner 直接写 join
#left join 左连接: 获取左表所有记录,即使右表没有对应匹配的记录
#right join 右连接: 获取右表所有记录,即使左表没有对应匹配的记录