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;
分页查询
原文：http://www.cnblogs.com/fufuxi869/p/6032479.html
