SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM CLOUD_TEACHER order by ORDERNUM) A WHERE ROWNUM <= :pageE ) WHERE RN >= :pageS 1、先在最里层排序、然后分页。