删除表A中的重复记录你可以直接用
delete from YOURTABLE t
where t.rowid!=(select max(a.rowid) from YOURTABLE a
where a.字段名=t.字段名)
delete from YOURTABLE t
where t.rowid!=(select max(a.rowid) from YOURTABLE a
where a.字段名=t.字段名)
where email in (select email from temp4_emails_checked group by email having count(email) > 1)
and rowid not in (select min(rowid) from temp4_emails_checked group by email having count(email )>1)
delete from temp a where rowid not in(select max(rowid) from temp b where a.重复主键=b.重复主键)
delete from temp a where rowid not in(select max(rowid) from temp b where a.c1=b.c1)是不是只能删掉c1列有相同值的记录?