SELECT campo1, campo2 FROM tabella1 HAVING COUNT(campo1) > 1