SELECT * FROM personnes WHERE nom IN
(SELECT nom FROM personnes GROUP BY nom HAVING COUNT(*) >= 2)
ORDER BY nom , prenom;