删除表中重复记录

delete from table1 where (a1) in    (select a1 from table1 group by a1 having count(*) >1)     and rowid not in(select min(rowid)from table1 group by a1     having count(*) >1);