Oracle分页查询格式:
例如查询第10页到20页数据
SELECT *
FROM ( SELECT ROWNUM AS rowno, t.*
FROM emp t
WHERE ROWNUM <= 20) TableA
WHERE TableA.rowno >= 10;
oracle分页ROWNUM只能用<或者<=,且必须大写,否则报错!
查询第一条和最后一条
select * from (select * from <table> order by <key>) where rownum=1;
union
select * from (select * from <table> order by <key> desc) where rownum=1;
参考文章
https://blog.csdn.net/use_admin/article/details/83622414