Which SQL keyword is used to eliminate duplicate rows from the result of a SELECT query?

Explanation

SELECT DISTINCT returns only distinct rows; UNIQUE is a constraint, not a SELECT modifier.