SELECT TOP
	20 "corpCode",
	"corpName",
	"id",
	"logType",
	"logTitle",
	"createBy",
	"createByName",
	"createDate",
	"requestUri",
	"requestMethod",
	"requestParams",
	"diffModifyData",
	"bizKey",
	"bizType",
	"remoteAddr",
	"serverAddr",
	"isException",
	"exceptionInfo",
	"userAgent",
	"deviceName",
	"browserName",
	"executeTime" 
FROM
	(
SELECT
	ROW_NUMBER () OVER ( ORDER BY "createDate" DESC ) PAGE_ROW_NUMBER,
	"corpCode",
	"corpName",
	"id",
	"logType",
	"logTitle",
	"createBy",
	"createByName",
	"createDate",
	"requestUri",
	"requestMethod",
	"requestParams",
	"diffModifyData",
	"bizKey",
	"bizType",
	"remoteAddr",
	"serverAddr",
	"isException",
	"exceptionInfo",
	"userAgent",
	"deviceName",
	"browserName",
	"executeTime" 
FROM
	(
SELECT
	a.corp_code AS "corpCode",
	a.corp_name AS "corpName",
	a.id AS "id",
	a.log_type AS "logType",
	a.log_title AS "logTitle",
	a.create_by AS "createBy",
	a.create_by_name AS "createByName",
	a.create_date AS "createDate",
	a.request_uri AS "requestUri",
	a.request_method AS "requestMethod",
	a.request_params AS "requestParams",
	a.diff_modify_data AS "diffModifyData",
	a.biz_key AS "bizKey",
	a.biz_type AS "bizType",
	a.remote_addr AS "remoteAddr",
	a.server_addr AS "serverAddr",
	a.is_exception AS "isException",
	a.exception_info AS "exceptionInfo",
	a.user_agent AS "userAgent",
	a.device_name AS "deviceName",
	a.browser_name AS "browserName",
	a.execute_time AS "executeTime" 
FROM
	js_sys_log a 
WHERE
	a.log_type = 'loginLogout' 
	) AS PAGE_TABLE_ALIAS 
	) AS PAGE_TABLE_ALIAS 
WHERE
	PAGE_ROW_NUMBER > 29640 
ORDER BY
	PAGE_ROW_NUMBER

这里贴错误信息