1、select t1.* from ( select t.* from test t where rownum<4 order by id desc) t1 where rownum<2 order by id asc


2、select * from ( select t.*,rownum r from test t where rownum<4 ) where r>1;