MySql
select tablename.* from tablename limit firstIndex,pageSize; firstIndex -------->开始索引 pageSize--------->页大小
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; |
|