数据库——伪列

1、rowid生成行的物理地址

2.rownum查询数据时标识查询结果的一个列

​
select rownum,e.* from emp order by deptno desc;

​

rownum用来过滤时只能判断其       小于等于？

select rownum,ename from emp where rownum <= 5;

工资最高的5位员工

select * from
(select * from emp 
order by sal desc) t
where rownum <= 5;

分页查询

select r, ename from
(select rownum r,emp.* from emp) t
where r > 5 and r <= 10;

3、union连接
查询结果的拼接
这几张表的查询字段要完全一致

复制dept表

create table dept2 as select * from dept

union去重，union all不去重

select * from dept
union all
select * from dept2;

插入多条数据

insert into dept
select '60','AAA','AAA'from dual
union
select '70','bbb','bbb'from dual;

 

转载于:https://my.oschina.net/u/3670318/blog/1620652