利用聚合函数来去重

select * FROM `test` 
WHERE `name` in (
　　select a.`name` from(
　　　　SELECT `name` FROM `test` GROUP BY `name` HAVING COUNT(*) >1
　　)a
)
and `id` not in (
　　select b.`id` from(
　　　　select min(`id`) as id from test group by `name` having count(*)>1
　　)b
)

 You can‘t specify target table ‘test‘ for update in FROM clause