Lesson 5 of 20
Remove duplicates with DISTINCT and limit results
Get a list of unique values and build a ranking that is short, stable and easy to verify.
17 minDiscovery access
By the end of this lesson
- Understand what makes DISTINCT unique
- Limit the number of returned records returned
- Associate LIMIT with a deterministic sort
Free Discovery access
Create your space to open this lesson.
Remove duplicates with DISTINCT and limit results is one of 8 lessons and 15 free exercises linked to an account. No card is required.
- Resume progress from your account
- Exercises with expected results and explanations
- Guided Sales Analysis project