日期:2014-05-16  浏览次数:20449 次

Oracle分页,采用三层嵌套



select * from
  (
     select rownum rn, t.* from
       (
  select * from t_user
       ) t where rownum <=4
  ) where rn >2

?



?