谢谢各位,问题我自己解决了代码如下:
# 我感觉下面同志回答肯定有对的,会不会还有其他地方引起的问题??
请给出修改代码,谢谢
SELECT
CSL.LOG_ID,
CSL.USER_ID,
CSL.USERNAME,
CSL.DESCRIPTION,
CSL.METHODS,
CSL.LOG_TYPE,
CSL.REQUEST_IP,
CSL.EXCEPTIONCODE,
CSL.EXCEPTION_DETAIL,
CSL.PARAMS,
CSL. TIME,
ROWNUM AS rowno
FROM
(
(
(SELECT * FROM CMU_USERS START WITH USER_ID = 1 CONNECT BY PRIOR USER_ID = PID ) U
LEFT OUTER JOIN CMU_SYSTEM_LOG CSL ON U .USER_ID = CSL.USER_ID
WHERE CSL.USER_ID IS NOT NULL ORDER BY TIME DESC
)
WHERE ROWNUM <= 20
) table_alias
WHERE table_alias.rowno > 1
图片:
这样的语句是可以查出数据的,加上分页查询就查不出了,前端使用的是easyUI框架:
SELECT
CSL.LOG_ID,
CSL.USER_ID,
CSL.USERNAME,
CSL.DESCRIPTION,
CSL.METHODS,
CSL.LOG_TYPE,
CSL.REQUEST_IP,
CSL.EXCEPTIONCODE,
CSL.EXCEPTION_DETAIL,
CSL.PARAMS,
CSL. TIME
FROM
(SELECT * FROM CMU_USERS START WITH USER_ID = 1 CONNECT BY PRIOR USER_ID = PID ) U
LEFT OUTER JOIN CMU_SYSTEM_LOG CSL ON U .USER_ID = CSL.USER_ID
WHERE CSL.USER_ID IS NOT NULL ORDER BY TIME DESC
如果告诉我另一种分页的查询方法也可以。一页显示20条