oracle 删除重复数据的几种方法

create table test_0210(id number,name varchar2(32),age number);

?s+dKx/t8PM,y0insert into test_0210 values(1,'abc',32);ITPUB个人空间IHW\y)`@%e+?[A]3|
insert into test_0210 values(2,'def',33);
*QG _$e'^s0insert into test_0210 values(3,'def',45);ITPUB个人空间f T2rN ?kI@\D
commit;

SQL> select * from test_0210;
/gRO'y@b0 ITPUB个人空间*y {!`x`1ga?:w
        ID NAME                                    AGEITPUB个人空间&s%tBVm6{QyB
---------- -------------------------------- ----------ITPUB个人空间he"tcY2{J!|
         1 abc                                      32ITPUB个人空间.a"Z9v1G{#m+C
         2 def                                      33ITPUB个人空间[A/Y2r?
         3 def                                      45
.BNg)`:v/r%rb4O'}0 

]Aj-C#U~Ot:bc01.使用rowid 效率高 直接定位到数据块地址,根据需要取max rowid 或 min rowid 只适合删除少量重复数据

SQL> delete from test_0210 where rowid not in (select max(rowid) from test_0210 group by name);ITPUB个人空间x