SQL: Dubletten finden

SELECT col1, ..., colN, COUNT(*)
FROM tab
GROUP BY col1, ..., colN
HAVING COUNT(*) > 1

Geschrieben von Frank Seitz in Datenbanken, SQL um 14:19