Oracle 高效删除重复数据（rowid）

文章目录

• 1 删除语句
• 2 基础数据

1 删除语句

delete 
  from scott.stu_info a
 where a.rowid > (select min(b.rowid) 
                    from scott.stu_info b 
                   where b.sno = a.sno);

 
 

2 基础数据

create table scott.stu_info (
  sno   number(3),
  sname varchar2(30)
);
-- 执行多次
insert into scott.stu_info(sno, sname) values(1, 'a');
insert into scott.stu_info(sno, sname) values(2, 'b');
insert into scott.stu_info(sno, sname) values(3, 'c');
commit;
select * from scott.stu_info;