/*
rowid : 伪列 每行记录所存放的真实物理地址
rownum : 行号 , 每查询出记录之后,就会添加一个行号
*/
select rowid,e.* from emp e;
--去除表中重复记录
create table p(
name varchar2(10)
);
insert into p values('A');
insert into p values('B');
insert into p values('C');
delete from p where
select rowid,p.* from p;
select distinct * from p;
delete from p p1 where rowid > (select min(rowid) from p p2 where p1.name = p2.name);