ORACLE中用rownum分页并排序的SQL语句

 

第一种： 

select b.* from
 ( select a.*, rownum row_num from
   (select t.* from A05_ORGANIZATION t order by org_name_en asc) a
  ) b
 where b.row_num  between 1 and 5  order by b.row_num asc

 

第二种（更高效）：

 

select b.* from
 ( select a.*, rownum row_num from
   (select t.* from A05_ORGANIZATION t order by org_name_en asc) a

   where rownum <=5
  ) b
 where b.row_num  >=1 order by b.row_num asc