JobPrax
SQL ORDER BY, LIMIT & DISTINCT — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
ORDER BY, LIMIT & DISTINCT
Sort, take the top rows and remove duplicates.
Your progress
0
/ 40
Start the first question
All levels
Basic (26)
Intermediate (7)
Advanced (7)
All
To do
Solved
1
Sort ascending
Basic
2
Sort descending
Basic
3
Top 5
Basic
4
Unique cities
Basic
5
Sort by text
Basic
6
Newest hires
Basic
7
Cheapest first
Basic
8
Customers A to Z
Basic
9
Longest serving first
Basic
10
Three most expensive
Basic
11
Five lowest salaries
Basic
12
Product categories
Basic
13
Job titles in order
Basic
14
Payment methods used
Basic
15
Latest five orders
Basic
16
Youngest students first
Basic
17
Smallest budgets first
Basic
18
By location, then name
Basic
19
Newest customers
Basic
20
Biggest transactions
Basic
21
Customer cities, sorted
Basic
22
Most stock first
Basic
23
Sales team by salary
Basic
24
Classes in the school
Basic
25
North month by month
Basic
26
First four customers
Basic
27
Sort by two columns
Intermediate
28
Distinct pairs
Intermediate
29
Skip and take
Intermediate
30
Sort by a calculation
Intermediate
31
NULLs at the end
Intermediate
32
Cheapest per category list
Intermediate
33
How many distinct?
Intermediate
34
Custom sort order
Advanced
35
Second highest salary
Interview
Advanced
36
Youngest and oldest hire
Advanced
37
Top 3 with ties
Interview
Advanced
38
Distinct cities, sorted by length
Advanced
39
Most recent order per status
Advanced
40
Page 3 of the catalogue
Advanced