一段sql语句，总是提示order by附近有语法错误。求指教
WITHaos_query_AS(SELECTTOP100PERCENTROW_NUMBER()OVER(ORDERBYrn_.ProjectCodeDESC)ASaos...
WITH aos_query_ AS (
SELECT
TOP 100 PERCENT ROW_NUMBER () OVER (ORDER BY rn_.ProjectCode DESC) AS aos_rn_,
rn_.*
FROM
(
SELECT
mms_project.projectname,
p.*
FROM
(
SELECT
*
FROM
tp_product
WHERE
ProjectCode IN (
'D58E3582AFA99040E27B92B13C8F2280',
'3D2172418CE305C7D16D4B05597C6A59',
'5b971ed70c8ee3cb'
)
) p
LEFT JOIN mms_project ON p.projectcode = mms_project.ProjectCode
) rn_
) SELECT
*
FROM
aos_query_
WHERE
aos_rn_ BETWEEN + 1
AND
ORDER BY
aos_rn_ 展开
SELECT
TOP 100 PERCENT ROW_NUMBER () OVER (ORDER BY rn_.ProjectCode DESC) AS aos_rn_,
rn_.*
FROM
(
SELECT
mms_project.projectname,
p.*
FROM
(
SELECT
*
FROM
tp_product
WHERE
ProjectCode IN (
'D58E3582AFA99040E27B92B13C8F2280',
'3D2172418CE305C7D16D4B05597C6A59',
'5b971ed70c8ee3cb'
)
) p
LEFT JOIN mms_project ON p.projectcode = mms_project.ProjectCode
) rn_
) SELECT
*
FROM
aos_query_
WHERE
aos_rn_ BETWEEN + 1
AND
ORDER BY
aos_rn_ 展开
展开全部
是AND后面、ORDER BY前面遗漏了一个数值
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
order by 前面为啥还要加and，又不是查询条件，把and删了
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
