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