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