SQL 删除重复记录

delete from user where   name in (select name from user group by name  having count(name) > 1)