---
description: '# Easy'
---

# 197. Rising Temperature(SQL)

```sql
# Write your MySQL query statement below
select w1.Id 
from Weather w1, Weather w2
where datediff(w1.recordDate, w2.recordDate) = 1 
    and w1.Temperature > w2.Temperature
```

{% hint style="danger" %}
时间差必须要用**datediff(date1, date2)**&#x6765;判断，此方法表明`date1-date2 = 1`
{% endhint %}
