匿名通过本文主要向大家介绍了Mysql,分页,查询语句等相关知识,希望本文的分享对您有所帮助
Mysql系列（十三）分页查询语句
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;
以上就是Mysql系列（十三）分页查询语句的内容，更多相关内容请关注微课江湖（）！