SELECT nom_table.ID, nom_table.champ, COUNT(*) FROM nom_table GROUP BY nom_table.champ

HAVING COUNT(*) > 1;