（7名同志回答都错了，救我）oracle语句错误，缺失右括号，怎么解决

Question

谢谢各位，问题我自己解决了代码如下：

# 我感觉下面同志回答肯定有对的，会不会还有其他地方引起的问题？？

请给出修改代码，谢谢

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条

Answer 1

 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 
) 

WHERE ROWNUM <= 20
) table_alias
WHERE table_alias.rowno > 1 ORDER BY TIME DESC