oracle 分页查询

-- 查询 第2条到第5条的数据
select * from (
	select t1.*,rownum as rnum from(select * from xtwh_gzry)t1 
	where rownum <=(5)
)t2 where t2.rnum>1

总的：