The first result can be achieved this way:

SELECT name FROM names HAVING COUNT(name)>1 GROUP BY 1

The second will use that same SQL in a subselect, like this:

SELECT name FROM names WHERE name in (SELECT name FROM names HAVING COUNT(name)>1 GROUP BY 1) ORDER BY 1

(I am using VFP 9. I don't know if the having clause is supported in VFP 6)