oracle分页查询

例如-- 查询工资从高到低排列第三到第五的员工信息,
select tt.*,rownum from 
(
	select t.*,rownum rn 
	from (select * from emp order by sal desc)t 
	where rownum <=5) tt
where tt.rn >=3

1、第一种用法：

select t2.* 
from (select rownum,t1.* 
		from (select * from Z)t1 
	  where rownum<=:pagenum)t2
where rownum>=0 

2、第二种用法

 select e2.*
 from   (select rownum r,z.*
     from z) e2
     where r between 0 and 6