Which SQL clause removes duplicate rows from the result set?

Prepare for the WGU BUS2770 D467 Exploring Data Exam. Dive into interactive quizzes and insightful flashcards, each featuring detailed explanations to optimize your learning experience, and get exam-ready!

Multiple Choice

Which SQL clause removes duplicate rows from the result set?

DISTINCT in a SELECT statement removes duplicate rows from the result. When you use SELECT DISTINCT with one or more columns, the database returns only unique combinations of the selected values, discarding any exact duplicates. For example, SELECT DISTINCT city FROM customers returns a list of unique cities, and SELECT DISTINCT city, state FROM customers returns unique city/state pairs. Other options don’t fit: ALL would keep every row, including duplicates; UNIQUE isn’t a standard keyword used in this context; RANDOM isn’t a valid SQL clause. So the way to eliminate duplicates is to use DISTINCT in the SELECT clause.

DISTINCT in a SELECT statement removes duplicate rows from the result. When you use SELECT DISTINCT with one or more columns, the database returns only unique combinations of the selected values, discarding any exact duplicates. For example, SELECT DISTINCT city FROM customers returns a list of unique cities, and SELECT DISTINCT city, state FROM customers returns unique city/state pairs. Other options don’t fit: ALL would keep every row, including duplicates; UNIQUE isn’t a standard keyword used in this context; RANDOM isn’t a valid SQL clause. So the way to eliminate duplicates is to use DISTINCT in the SELECT clause.

More practice questions