delete table1 where rowid not in (select max(rowid) from table1 group by col1 ,col2 )
来源: http://www.phpxs.com/code/1008714/