JobPrax
SQL Window functions: ranking — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
Window functions: ranking
ROW_NUMBER, RANK, DENSE_RANK, NTILE.
Your progress
0
/ 40
Start the first question
All levels
Basic (25)
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
Number by salary
Basic
7
Rank by price
Basic
8
Dense rank of salaries
Basic
9
Each customer's orders, numbered
Basic
10
Rank inside a category
Basic
11
Maths final ranking
Basic
12
June region ranking
Basic
13
Priciest per category
Basic
14
Signup order
Basic
15
Top half, bottom half
Basic
16
Oldest hand in each team
Basic
17
Biggest transactions per account
Basic
18
Project budget ranking
Basic
19
Stock levels
Basic
20
Oldest in the class
Basic
21
Top three salary levels
Basic
22
Each customer's latest order
Basic
23
West's best months
Basic
24
Login count so far
Basic
25
RANK next to DENSE_RANK
Basic
26
Top earner per department
Interview
Intermediate
27
Top 2 per department
Interview
Intermediate
28
QUALIFY
Intermediate
29
Best-selling product per category
Intermediate
30
Remove duplicates with ROW_NUMBER
Interview
Intermediate
31
Class rank in Maths
Intermediate
32
Percent rank
Intermediate
33
Nth highest with DENSE_RANK
Interview
Advanced
34
Top customer per city
Advanced
35
Second order of each customer
Advanced
36
Rank regions each month
Advanced
37
Months each region won
Advanced
38
Median per department
Advanced
39
Students in top 20%
Advanced
40
Salary gap to department top
Advanced