数据库分页SQL

ORACLE数据库分页SQL

 代码示例：

SELECT *

  FROM (SELECT ROWNUM AS rowno, t.*

          FROM emp t

         WHERE hire_date BETWEEN TO_DATE ('20060501', 'yyyymmdd')

                             AND TO_DATE ('20060731', 'yyyymmdd')

           AND ROWNUM <= 20) table_alias

 WHERE table_alias.rowno >= 10;

来源链接：

https://www.cnblogs.com/pypua/p/12896984.html

 

MYSQL数据库分页SQL

代码示例：

select * from users where id>100073 order by id asc limit 20