oracle sql 分页

string sql = "(select * from CorporationMainTable2 order by rowid) ta";

       sql = "(select rownum rn , ta.* from " + s + " where  rownum<" + (end + 1) + ")";

       sql = "select * from " + s + " where rn >= " + begin;

 

 

 

select *

  from (select rownum rn, ta.*

          from (select *

                  from CorporationMainTable

                 where *

                 order by CreditID desc) ta

         where rownum <= 4)

 where rn > 0

 

转载于:https://www.cnblogs.com/xsmhero/archive/2011/08/01/2124239.html