今天我重新写了一下2019/1/30,用的sql server:
select a.id from Weather a,Weather b
where cast(a.RecordDate as datetime) = cast(b.RecordDate as datetime)+1
and a.Temperature>b.[Temperature]
知识点:
o_date(a.dates)=to_date(b.dates)+1
where 条件(获取与昨天进行比较的条件)
答案1:
select a.id from ZZZ_TEXT a ,ZZZ_TEXT b where to_date(a.dates)=to_date(b.dates)+1 and a.Temperature>b.Temperature
方法2:
知识点: inner join
inner join(等值连接) 只返回两个表中联结字段相等的行
答案2:
select a.id from ZZZ_TEXT a
inner join ZZZ_TEXT b on to_date(a.dates)=to_date(b.dates)+1 and a.Temperature>b.Temperature