8000 Update README.md · ieshreya/sql-50-leetcode@7f39c35 · GitHub
[go: up one dir, main page]

Skip to content

Commit 7f39c35

Browse files
authored
Update README.md
1 parent cd81e88 commit 7f39c35

File tree

1 file changed

+2
-0
lines changed

1 file changed

+2
-0
lines changed

README.md

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -88,6 +88,8 @@ ON
8888
DATEDIFF(w1.recordDate, w2.recordDate) = 1
8989
WHERE
9090
w1.temperature > w2.temperature;
91+
92+
-- OR We can use lag() window function to get previous_temperature and record_date columns beside our table and filter it
9193
```
9294

9395

0 commit comments

Comments
 (0)
0