删除数据库中的重复项

delete a from (select name,min(id) where name in (select name from a group by name having count(1) > 1) group by name) b where a.name = b.name and a.id != b.id

 

 

a 为要删除的数据表