To get all the clients out without repeating the names is very easy.
SELECT distinct firstname FROM client
And to get all the clients whose name is repeated more than once is not very complicated either.
SELECT count(*), firstname FROM client GROUP BY firstname HAVING COUNT(*) > 1;
What I can not get out is a list of all the clients whose name is repeated, so that if there are two "Juan" show me the record of each one.