☰
$
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
/
ranking-functions
[challenge]
lesson 29
ROW_NUMBER, RANK, DENSE_RANK
>
theory
examples
[2]
challenges
[0/4]
loading company.db…
← prev:
COALESCE, NULLIF, and IIF
next:
PARTITION BY
→
$
tools
▸