SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

DISTINCT and its counterpart, ALL, can be used together on single field in a SELECT statement.

ORDER BY can be combined with the SELECT statements.