oracle取前10行
select * from tableName where rownum <11;
oracle取10至20行
select * from (select t.*,rownum r from tableName t where rownum<21) where r >=10;
oracle取前10行
select * from tableName where rownum <11;
oracle取10至20行
select * from (select t.*,rownum r from tableName t where rownum<21) where r >=10;