SQL DISTINCT Quiz

This SQL quiz is about SELECT DISTINCT and COUNT(DISTINCT ...). You will see how duplicates are judged across whole rows, how NULL and letter case behave, and where DISTINCT is allowed in a query.

Easy 10 questions ~5 minutes Pass at 80% SQLite

Choose a mode

Playing as a guest: sign in to keep your XP and streak.

Sample question

Question 1 of 10

What does this query return?

CREATE TABLE orders (customer TEXT, city TEXT);
INSERT INTO orders VALUES ('Ana', 'Paris'), ('Ben', 'Rome'), ('Ana', 'Paris'), ('Cy', 'Paris'), ('Ben', 'Lyon');
SELECT DISTINCT customer FROM orders ORDER BY customer;
Show the answer

B. Ana Ben Cy DISTINCT keeps one copy of each different row. Ana and Ben appear twice in the table but once in the result.

What this quiz covers

  • Removing duplicate rows with SELECT DISTINCT
  • DISTINCT applies to the whole row, not one column
  • Counting unique values with COUNT(DISTINCT column)
  • How NULL and letter case affect duplicates
  • DISTINCT vs GROUP BY

Questions people ask

Do I need an account?

No. Anyone can play. Sign in to keep your XP, streak, badges and history.

Can I retake it?

Yes. Your best score is kept, and the questions and answers are shuffled each time.