Oracle实现分页

1、采用ROWNUM关键字(三层嵌套)

select * from (
select a.*,ROWNUM num from
(select * from tablename) a
where ROWNUM<=15)

where num>=5; --返回5到15行数据

2、采用row_number解析函数进行分页(效率更高)

select t2.*,rowNumber from (
select t1.*,row_number() over (order by t1.serial_no) as rowNumber from tablename t1)t2
where rowNumber between 5 and 15; --返回5到15行

数据解析函数能用格式函数over(pertion by 字段 order by 字段)，pertion 按照某个字段分区，order按照某个字段排序