Localizar duplicatas no Oracle / Find duplicate records in Oracle

Lozalizar registros duplicados no Oracle:


select 
  c.cnpj,
  count(*)
from
  contato c
  having count(c.cnpj) > 1
  group by c.cnpj