DISTINCT
Removes duplicate rows from a query's result.
SELECT DISTINCT rating FROM film;
When to use
PP 04 Q4.4 contrasts it with UNIQUE: DISTINCT removes duplicates from a SELECT result (DML), whereas UNIQUE Constraint stops duplicates being entered into a column (DDL). PS 04 uses COUNT(DISTINCT rental_id) after joins that multiply rows.
See PP 04.