To eliminate duplicate rows in a query, the ________ qualifier is used in the SQL Select command.
A) alter
B) distinct
C) check
D) specific

Question

Quizplus · Accepted Answer

The Distinct qualifier is used in the SQL Select command to eliminate duplicate rows and retrieve only unique rows from a table or multiple tables based on the specified columns in the query. It is useful when dealing with large amounts of data as it helps to optimize performance and reduce processing time. The other options, Alter, Check, and Specific, are not relevant in this context.

To Eliminate Duplicate Rows in a Query, the ________ Qualifier