DISTINCT Deduplication
Beginner
A signup form has a "city" dropdown that should list every city where at least one of your users lives, with each city appearing only once even if many users share it.
Write a query that returns the distinct values of the city column of users.
Constraints
- Return only the
citycolumn - Each city appears exactly once
- Row order does not matter
Hints
Hint 1
DISTINCT goes right after SELECT.
Hint 2
Selecting name as well would make every row unique again, so select only city.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.