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;