Memo MySQL

Recherche de doublon :

SELECT COUNT() AS nbr_doublon, champ1, champ2
FROM my_table where champ3=600
GROUP BY champ1, champ2 HAVING COUNT() > 1;