oracle 采用三层结构分页后有的页数据重复问题
SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT ajbh FROM aj_jbxx_test WHERE SLDW like '1507%' AND czbs < 3 ORDER BY FASJXX DESC ) A WHERE ROWNUM <= 72) WHERE RN > 64;SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT ajbh FROM aj_jbxx_test WHERE SLDW like '1507%' AND czbs < 3 ORDER BY FASJXX DESC ) A WHERE ROWNUM <= 64) WHERE RN > 56;SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT ajbh FROM aj_jbxx_test WHERE(czbs < 3) AND (SLDW like '1507%') ORDER BY FASJXX DESC ) A WHERE ROWNUM <= 80) WHERE RN > 72;
?
结果前两页查询语句得到的结果是一样的，第三个结果就和前面的不一样。
?
百思不得其解啊，求各位大神给予指点。
?
数据文件在附件中。
