分頁查詢,oracle分頁查詢
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;