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

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

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

请给出修改代码，谢谢

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条

 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

ORDER BY 不能在括号里面
正确是这样：
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

（
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

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 AND ROWNUM <= 20)
WHERE table_alias.rowno > 1
ORDER BY TIME DESC

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 AND ROWNUM <= 20
) table_alia WHERE table_alias.rowno > 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
)
ORDER BY TIME DESC
WHERE ROWNUM <= 20
) table_alias
WHERE table_alias.rowno > 1

order by不能在括号里

    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
            (
                (
                    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

 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 (select * 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)temp WHERE ROWNUM <= 20
) table_alias  WHERE table_alias.rowno > 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
( select * 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