java吧 关注：1,260,360贴子：12,758,280
- 14回复贴，共1页
数据库怎么可能错，肯定你写错了
2017-09-30 10:17:10,711 [http-nio-8080-exec-7] DEBUG [com.ltgk.dao.PkjlbDao.SelectAttendance] - ==>
Preparing:
SELECT * FROM
( SELECT v.*, ROWNUM r FROM
(SELECT * FROM ( SELECT DISTINCT j.JSH, j.kch, b.XH, j.kcm FROM PKJLB j LEFT JOIN PKXSB b ON j."ID" = b.pkjlid ) T
LEFT JOIN
( SELECT * FROM
( SELECT ROW_NUMBER () OVER ( PARTITION BY TK.KCH, TK.TKRZH ORDER BY TK.TJSJ DESC ) rn,
tk.*
FROM TKSPB tk ) WHERE rn = 1 ) tk ON TK.tkrzh = T .xh WHERE T .XH IS NOT NULL
) v
) where r>? and r < =?
2017-09-30 10:17:10,713 [http-nio-8080-exec-7] DEBUG [com.ltgk.dao.PkjlbDao.SelectAttendance] - ==> Parameters: 0(Integer), 20(Integer)
2017-09-30 10:17:10,795 [http-nio-8080-exec-7] DEBUG [com.ltgk.dao.PkjlbDao.SelectAttendance] - <== Total: 9
这是日志查出来的信息， 9条
我用集合接收 返回长度是6 输出在面板也是6 上面是sql 请大牛给看看！
Preparing:
SELECT * FROM
( SELECT v.*, ROWNUM r FROM
(SELECT * FROM ( SELECT DISTINCT j.JSH, j.kch, b.XH, j.kcm FROM PKJLB j LEFT JOIN PKXSB b ON j."ID" = b.pkjlid ) T
LEFT JOIN
( SELECT * FROM
( SELECT ROW_NUMBER () OVER ( PARTITION BY TK.KCH, TK.TKRZH ORDER BY TK.TJSJ DESC ) rn,
tk.*
FROM TKSPB tk ) WHERE rn = 1 ) tk ON TK.tkrzh = T .xh WHERE T .XH IS NOT NULL
) v
) where r>? and r < =?
2017-09-30 10:17:10,713 [http-nio-8080-exec-7] DEBUG [com.ltgk.dao.PkjlbDao.SelectAttendance] - ==> Parameters: 0(Integer), 20(Integer)
2017-09-30 10:17:10,795 [http-nio-8080-exec-7] DEBUG [com.ltgk.dao.PkjlbDao.SelectAttendance] - <== Total: 9
这是日志查出来的信息， 9条
我用集合接收 返回长度是6 输出在面板也是6 上面是sql 请大牛给看看！
扫二维码下载贴吧客户端
下载贴吧APP
看高清直播、视频！
看高清直播、视频！
贴吧热议榜
- 1MCN开喷隋坡本人就一臭打工的2373360
- 2陈奕迅报平安1907069
- 3王楚钦换球拍仍光速赢球1647968
- 4YOU宣布退出XLG1427976
- 5小明剑魔求粉丝打赏礼物养自家猫1014494
- 6小米玄戒O1采用第二代3nm工艺889625
- 7潘展乐200自夺冠孙杨第八632352
- 8WBG零封FPX终结六连败573091
- 9小米YU7即将亮相449702
- 10雷霆抢七淘汰掘金430626
