Buscar duplicados en mysql a las 9:36

SELECT *,count(*) AS 'Num_repeticiones'

FROM tabla

GROUP BY campo

HAVING count(*)=1;