mostrar registros repetidos

[vtdeleon]

Saludos

Código SQL [-]
select distinct campo1, campo2
FROM tabla1 WHERE campo1 In (SELECT campo1 FROM
tabla1 As Tmp GROUP BY campo1 HAVING Count(*)>1)
ORDER BY campo1;