|
在数据集的分页取数据方案中设定每页记录数为100与不设定分页取数据(设定-1)的差异。
测试后,如果不设定分页取数据是正常的,设定了分页取数据造成数据混乱,一些数据重复,而另一部分数据不足。但是总数是一样的。
附上:SQL 事假探查器 查询的SQL语句
SELECT POLICEACTION.eventid, POLICEACTION.weifamanid, POLICEACTION.suitongrenyuan, POLICEACTION.weifamiaoshu, POLICEACTION.chahuotime1, POLICEACTION.staquyu, POLICEACTION.chahuorenyuan1, POLICEACTION.chahuorenyuan2, POLICEACTION.chengban1, POLICEACTION.chengban2, POLICEACTION.XLBH, POLICEACTION.ZTBH, POLICEACTION.CHDD, POLICEACTION.CHDW1, POLICEACTION.CHDW2, POLICEACTION.CBDW1, POLICEACTION.CBDW2, POLICEACTION.CHYY, POLICEACTION.TSRY, POLICEACTION.HSMJ1, POLICEACTION.HSMJ2, POLICEACTION.HSDW1, POLICEACTION.HSDW2, WEIFAMANINFO.manname, WEIFAMANINFO.othername, WEIFAMANINFO.sex, WEIFAMANINFO.minzu, WEIFAMANINFO.personcode, WEIFAMANINFO.age, WEIFAMANINFO.wenhua, WEIFAMANINFO.hujisheng, WEIFAMANINFO.hujishi, WEIFAMANINFO.hujidetail, WEIFAMANINFO.zaihuqu, WEIFAMANINFO.zaihulu, WEIFAMANINFO.zaihudetail, WEIFAMANINFO.gongzuodanwei, WEIFAMANINFO.lianxifangshi, WEIFAMANINFO.opman, WEIFAMANINFO.shengao, WEIFAMANINFO.tezheng, WEIFAMANINFO.ZJLXH, POLICEACTION.DJR, POLICEACTION.DJSJ, POLICEACTION.DJBM, POLICEACTION.YYJS, POLICEACTION.FRBS, POLICEACTION.ENDTIME, POLICEACTION.CRWF
FROM POLICEACTION, WEIFAMANINFO
WHERE (POLICEACTION.WEIFAMANID = WEIFAMANINFO.MANID) AND (( KSRQ >= '' and KSRQ <= '2008-3-28' and POLICEACTION.weifamanid in (select weifamanid AS "人员编号" from POLICEACTION group BY POLICEACTION.weifamanid HAVING COUNT(POLICEACTION.eventid) = 3))) |
|