Mysql Series (Thirteen) Paging Query Statement
MySql
select tablename.* from tablename limit firstIndex,pageSize;
firstIndex -------->开始索引
pageSize--------->页大小Oracle
select * from (
select a.*,ROWNUM rn from tablename a where ROWNUM<=(firstIndex+pageSize)
) where rn>firstIndex;
2.
select * from(select * from(select p.*,ROWNUM rn from tablename )p where p.rownumber>firstIndex) where rownum>pageSize;
and above This is the content of the paging query statement in the Mysql series (13). For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com)!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
