# \#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`