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.

30 free days of SQL Pro on registration, subject to the 34 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.