# #197 Rising Temperature

#### [https://leetcode.com/problems/rising-temperature](https://leetcode.com/problems/rising-temperature)

{% tabs %}
{% tab title="MS SQL Server" %}
```sql
SELECT W2.id
FROM Weather W1, Weather W2
WHERE DATEDIFF(DAY, W1.recordDate, W2.recordDate) = 1
AND W2.temperature > W1.temperature;
```
{% endtab %}
{% endtabs %}
