清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

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