Oracle分页查询

--以scott账户下的emp表为例子

Select * From emp

--查询第6~11数据

--1.分页
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