Dubletten in einer MySQL Tabelle anzeigen

SELECT A.uid, B.uid, A.name, A.first_name
FROM table_name AS A
JOIN table_name AS B
ON ( A.name = B.Name
   AND A.first_name = B.first_name
   AND NOT (A.uid = B.uid)
   )
ORDER BY A.name