Question Details

Detailed explanation and options for the selected question.

Which command is used to remove duplicate rows from query results?

A. SELECT DISTINCT
B. DELETE DUPLICATES
C. REMOVE DUPLICATE ROWS
D. DISTINCT ROWS

Explanation:

SELECT DISTINCT removes duplicate rows from query results. DELETE DUPLICATES and the others are invalid commands.