SQL Knowledge Center · About ·
Easy Interactive Online SQL Training for Beginners

SQL DISTINCT Tutorial - Interactive Database Lesson

Lesson 9 of 31

Lessons

1. SELECT *
2. SELECT specific columns
3. WHERE ... Equals
4. WHERE ... Greater than
5. WHERE ... Greater than or equal
6. AND
7. OR
8. IN
9. DISTINCT
10. ORDER BY
11. LIMIT # of returned rows
12. COUNT(*)
13. COUNT(*) ... WHERE
14. SUM
15. AVG
16. MAX and MIN
17. GROUP BY
18. Nested queries
19. NULL
20. Date
21. Inner joins
22. Multiple joins
23. Joins with WHERE
24. Left joins
25. Table alias
26. Column alias
27. Self joins
28. LIKE
29. CASE
30. SUBSTR
31. COALESCE

DISTINCT

Interactive SQL Tutorial

By putting DISTINCT after SELECT, you do not return duplicates.

For example, if you run
SELECT DISTINCT gender, species FROM friends_of_pickles WHERE height_cm < 100;, you will get the gender/species combinations of the animals less than 100cm in height.

Note that even though there are multiple male dogs under that height, we only see one row that returns “male” and “dog”.

Can you return a list of the distinct species of animals greater than 50cm in height?

SQL:

Query Result:

Available Tables:

Languages: English, Español, Portoghese, Italiano, Français, 日本語, Deutsch, اللغة العربية

2017 - 2023 · SQL-Easy.com. A Beekeeper Studio Project.

About · Cookie Policy