SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (此处写查询的记录) A WHERE ROWNUM <= 5 ) WHERE RN >= 1 1为起始记录 5为结束记录