SELECT DISTINCT ... is an easy way to select unique records.

If you are looking for a list of the records that have duplicates, you should look at the HAVING-clause