☰
$
cd ../lessons
xp
0
# lessons
close
# window-functions
01
ROW_NUMBER, RANK, DENSE_RANK
>
02
PARTITION BY
03
LAG and LEAD
04
Running Totals and Moving Averages
05
FIRST_VALUE and LAST_VALUE
⤓ download notes (.md)
~
/
lessons
/
window-functions
/
partition-by
[challenge]
lesson 30
PARTITION BY
>
theory
examples
[2]
challenges
[0/3]
project
loading company.db…
← prev:
ROW_NUMBER, RANK, DENSE_RANK
next:
LAG and LEAD
→
$
tools
▸