ORACLE分页查询、第一条和最后一条记录

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.youkuaiyun.com/use_admin/article/details/83622414