If you want to remove duplicates from a result set, which command should you use?
A)SELECT AS
B)SELECT UNIQUE
C)SELECT ONLY
D)SELECT DISTINCT

Question

Quizplus · Accepted Answer

The correct command to remove duplicates from a result set is SELECT DISTINCT. This command will select only the unique values from the specified column(s) in the result set. Option A (SELECT AS) is used to rename a column or table, option B (SELECT UNIQUE) is not a valid command in SQL, and option C (SELECT ONLY) is used to select only a specific table in a query with multiple tables.

If You Want to Remove Duplicates from a Result Set