oracle 分页语句

  
  select *
    from (SELECT rownum as rnum, t.* FROM relation t)
   where rnum > 1
     and rnum < 3;