Create Table Werther
(
Id int primary key identity(1,1) not null,
RecordDate date not null,
Temperature int not null,
)


insert into Werther(RecordDate,Temperature)  values('2015-01-01','10'),('2015-01-02','25'),('2015-01-03','20'),('2015-01-04','30')


select l.Id from Werther l,werther l1  where dateDiff(day,l1.RecordDate,l.RecordDate)=1 and l.Temperature>l1.Temperature