mysql删除冗余数据

mysql> delete from student where id in (    select c.id from     (        select id from student a where exists        (            select id from student b where a.name=b.name group by name having count(id) > 1         )        group by name    ) c);