SELECT NAME, COUNT (NAME) FROM TABLE1 GROUP BY NAME
HAVING COUNT (NAME) > 1