Tag: having

SELECT `name`, COUNT( * ) c
FROM `table`
GROUP BY `name` 
HAVING c >1