复制select a,这些问题b,c,d from (select a,b,c,d from T orderby c) where rownum<=30 minus select a,b,c,d from (select a,b,c,d from T orderby c) where rownum <=20; 或者: select * from (select rownum rn,a.* from (select a,b,c,d from T orderby c) a )where rn between 21 and 30; 1.2.3.4.5.