SELECT * FROM --最好把生成的列手动写上代替* (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM <= 40) b WHERE b.RN >= 21 网上找的,据说效率很高,注释是我写的。。。