表结构如下
create table AJ_JBXX_TEST ( AJBH VARCHAR2(23) not null, FASJXX VARCHAR2(14), SLDW CHAR(12), CZBS VARCHAR2(1) )
分页语句如下
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;
结果前两页查询语句得到的结果是一样的,第三个结果就和前面的不一样。
百思不得其解啊,求各位大神给予指点。
数据文件在附件中。