开发笔记：selectfrom具体执行相关知识介绍及案例分析

create table p(
name varchar2(10)
);
insert into p values(‘黄伟福‘);
insert into p values(‘赵洪‘);
insert into p values(‘杨华‘);

select rowid,p.* from p;

select distinct * from p;

select min(rowid) from p p1 where p1.name = p1.name

select rowid,p1.* from p p1 where rowid = (select min(rowid) from p p2 where p1.name = p2.name);

delete from p p1 where rowid > (select min(rowid) from p p2 where p1.name = p2.name);
select rowid,p.* from p;