SQL Ranking Functions 101: RANK, DENSE_RANK, and ROW_NUMBER
In this video, we go through the basics of the three most common ranking functions in SQL: RANK(), DENSE_RANK(), and ROW_NUMBER().
RANK() example:
(requires sign-in) https://data.world/medianpulse/sql-ca...
DENSE_RANK() example:
(requires sign-in) https://data.world/medianpulse/sql-ca...
RANK() with PARTITION:
(requires sign-in) https://data.world/medianpulse/sql-ca...
ROW_NUMBER():
(requires sign-in) https://data.world/medianpulse/sql-ca...
ROW_NUMBER() with PARTITION:
(requires sign-in) https://data.world/medianpulse/sql-ca...
⏱️ Timestamps:
0:00 - Definitions
1:58 - Dataset preview
2:50 - RANK() example
4:10 - DENSE_RANK() example
4:50 - RANK() with PARTITION example
6:50 - ROW_NUMBER() example
8:33 - ROW_NUMBER() with PARTITION example
9:15 - Final thoughts