oracle数据库分页话语
oracle数据库分页语句
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;