本文共 317 字，大约阅读时间需要 1 分钟。

以scott账户下的emp表为例子

首先查询emp表：Select * From emp

1.演示分页查询第6~11数据

Select * From (Select emp.empno,Rownum r From emp Where Rownum<=11)  Where r>=6

2.先进行排序，再分页查询

Select * From  emp e Order By e.empno Desc

Select * From (Select e.*,Rownum r_num From(Select * From emp e Order By e.empno Desc )e)b Where b.r_num between 6 And 11           

 

 

 

 

 

 

 

 

转载地址：http://ckcqi.baihongyu.com/