oracle分页查询

实例： 1.PROJECT：要查询的表

            2.每页10行pageindex=2,共两页pagesize=10
            3.pageindex*pagesize=20，（pageindex-1）*pagesize+1=11

SELECT TEMP.* FROM (SELECT INNER_TEMP.*, ROWNUM RN FROM
 ( SELECT * FROM PROJECT  ORDER BY TO_NUMBER(ID) DESC )
 INNER_TEMP WHERE ROWNUM <= 20 ) TEMP WHERE TEMP.RN >= 11 ;

具体带参sql:

                1.table ：要查询的表

                2.页码：pageindex,每页行数：pagesize

                3.最多去取值数量：pageindex*pagesize，

                   从第几行开始取值（pageindex-1）*pagesize+1

                4.rownum:将查询结果进行index++

 select a.* from (select b.*,rownum rn from (select * from  table order by id desc)
  b.rn<=pageindex*pagesize) a
  where a.rn>=(pageindex-1)*pagesize+1