--伪列
select emp.*,rownum from emp;
--分页:n页,一页a列
select * from emp where rownum between a*n-2 and a*n
--示例:查询工资4到第6名的员工信息
select * from
(select e.*,rownum rn from
(select * from emp order by sal) e) employee
where rn between 4 and 6;
--示例:查询工资4到第6名的员工信息
select * from emp order by sal
limit 4,2 ;
Sqlserver分页:通过TOP函数来实现
--示例:查询工资4到第6名的员工信息
select top 2 * from
(select *,row_number() over(order by sal) rownum from emp )x where x.rownum>4
--利用top 和 not in 实现,效率更高
select top 2 * from emp where empno not in
( select top 4 empno from empno order by sal)
order by sal
Oracle分页:ORCALE数据库实现分页查询可以使用使用rownum 伪列方法。--伪列 select emp.*,rownum from emp;--分页:n页,一页a列 select * from emp where rownum between a*n-2 and a*n--示例:查询工资4到第6名的员工信息 select * from (se...