Skip to content
Skills
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Home
/
Data Analyst
/
Easy
/
DISTINCT with two columns
easy
5 pts · first answer counts
sql
distinct
DISTINCT with two columns
What does this query return?
Choose one answer
A.
Each unique pair of city and state once
B.
Each unique city once, with any one state
C.
Only cities that appear in a single state
D.
Each unique state once, with its first city
Submit answer
Report a problem
← Previous
Rows from a CROSS JOIN
Next →
Column alias in WHERE fails
All easy Data Analyst questions
Discussion
0
Join free
to post in the discussion.
Related questions
WHERE vs HAVING
Data Analyst
Which join keeps all customers
Data Analyst
COUNT(*) vs COUNT(column)
Data Analyst
Finding NULL values
Data Analyst
COUNT(DISTINCT) with NULLs
Data Analyst
Rows from an INNER JOIN
Data Analyst
UNION vs UNION ALL
Data Analyst
AVG with a NULL value
Data Analyst
More SQL questions
