delete table1 where rowid not in (
select max(rowid) from table1 group by col1 ,col2  )