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按照某个字段排序