oracle数据库分页语句

1、select t1.* from ( select t.* from test t where rownum<4 order by id desc) t1 where rownum<2 order by id asc2、select * from ( select t.*,rownum r from test t where rownum<4 ) where r>1;