DataDesk
All topics
Window functions: ranking — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
Window functions: ranking
ROW_NUMBER, RANK, DENSE_RANK, NTILE.
0
/ 20 solved
All levels
Basic (5)
Intermediate (7)
Advanced (8)
All
To do
Solved
1
Row numbers
Basic
2
RANK with ties
Basic
3
DENSE_RANK
Basic
4
Rank inside groups
Basic
5
Quartiles with NTILE
Basic
6
Top earner per department
Interview
Intermediate
7
Top 2 per department
Interview
Intermediate
8
QUALIFY
Intermediate
9
Best-selling product per category
Intermediate
10
Remove duplicates with ROW_NUMBER
Interview
Intermediate
11
Class rank in Maths
Intermediate
12
Percent rank
Intermediate
13
Nth highest with DENSE_RANK
Interview
Advanced
14
Top customer per city
Advanced
15
Second order of each customer
Advanced
16
Rank regions each month
Advanced
17
Months each region won
Advanced
18
Median per department
Advanced
19
Students in top 20%
Advanced
20
Salary gap to department top
Advanced