---
# System prepended metadata

title: \#197 Rising Temperature
tags: [leetcode, leetcode-easy, sql]

---

# \#197 Rising Temperature
## *取得昨天比今天高溫的日期id*
## Log
 - build 20210424 by syhuang

## xxx
 - xxx
```javascript=
```
## 初見
 - join搭配daydiff
```sql=
select w1.id
  from Weather w1
  join Weather w2 on DATEDIFF(day, w2.recordDate, w1.recordDate)=1  and w2.Temperature < w1.Temperature
```
## 備註
 - 初見即畢業
## 參考
###### tags: `leetcode`, `leetcode-easy`, `sql`