以表table为例, 表table中只有一个字段a
1) 找出重复记录
select a from table group by a having count(*) > 1
2) 删除重复记录
delete from table A where A.rowid < (select max(B.rowid) from table B where A.a = B.a)
以表table为例, 表table中只有一个字段a
1) 找出重复记录
select a from table group by a having count(*) > 1
2) 删除重复记录
delete from table A where A.rowid < (select max(B.rowid) from table B where A.a = B.a)