SELECT id, SUM(COUNT(`name`)) as sum_name FROM `table` GROUP BY `name` HAVING COUNT(`name`)>1
SELECT id, SUM(COUNT(`name`)) as sum_name FROM `table` HAVING COUNT(`name`)>1
GROUP BY `name`
