SELECT *
FROM cds_star_info
GROUP BY surname, name
HAVING count(surname) > 1 AND count(name) > 1
ORDER BY surname ASC

Ho usato questa, dovrebbe andare bene...se pensate sia sbagliata fatemelo sapere!