oracle去除重复数据sql

2019PHP高薪工程师学习路线图....>>>

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