Oracle 去重机制

一、分析函数(灵活性高,效率一般)

delete from test t

 where t.rowid in (select rid

                     from (select t1.rowid rid,

                                  row_number() over(partition by t1.col_2, t1.col_3 order by 1) rn

                             from test t1) t1

                    where t1.rn > 1);

二、分组函数(灵活性一般,效率高 )

delete from test t

 where t.rowid not in

       (select max(rowid) from test t1 group by t1.col_2, t1.col_3);