DISTINCT removes duplicate rows from the result. Applied to several columns, it applies to the combination of those columns. It is used to list the different values of a column, but if it hides unwanted duplicates, it is better to look for the cause, for example a join.
Example
SELECT DISTINCT pays FROM clients;