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;
select distinct campo1, campo2 FROM tabla1 WHERE campo1 In (SELECT campo1 FROM tabla1 As Tmp GROUP BY campo1 HAVING Count(*)>1) ORDER BY campo1;