删除重复行的方法

delete from TABLE_name t1
 where t1.rowid >
 (select min(rowid) from TABLE_name t2
 where t1.name = t2.name
 group by name
 having count(name) > 1);

 比较简单 就不多说了