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