Predict DISTINCT Count
Predict Output Easy
Question
Categories are: 'a', 'b', 'a', 'c', 'b', 'a'. How many rows does DISTINCT return?
Code
SELECT DISTINCT category FROM items;
Hint
DISTINCT removes duplicates.
Explanation
DISTINCT returns unique values only. The distinct categories are 'a', 'b', 'c' — 3 rows.
Related Resources
Related Lessons
- Select Queries
Learn DISTINCT.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.