oracle 分页并排序

①采用rownum关键字(三层嵌套)

SELECT * FROM(
  SELECT A.*,ROWNUM  num FROM 
  (SELECT * FROM t_order)A
  WHERE
  ROWNUM<=15)
WHERE num>=5;

--返回第5-15行数据

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

SELECT xx.* FROM(
SELECT t.*,row_number() over(ORDER BY o_id)AS num
FROM t_order t
)xx
WHERE num BETWEEN 5 AND 15;