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);