[Err] 42000 - [SQL Server]')' 附近有语法错误。
SELECTTOP10*FROM(SELECTROW_NUMBER()OVER(ORDERBYFILE_ARCNODESC)ASrownumber,*FROM(SELEC...
SELECT
TOP 10 *
FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY FILE_ARCNO DESC) AS rownumber,*
FROM
(
SELECT
*
FROM
ARC_FILE_ACC
WHERE
FILE_ARCNO = '11'
OR FILE_NO = '11'
OR TITLE = '11'
)
) AS a
WHERE
rownumber > 0
就没发现哪里不对 一直报')'附近有语法错误 郁闷死了 展开
TOP 10 *
FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY FILE_ARCNO DESC) AS rownumber,*
FROM
(
SELECT
*
FROM
ARC_FILE_ACC
WHERE
FILE_ARCNO = '11'
OR FILE_NO = '11'
OR TITLE = '11'
)
) AS a
WHERE
rownumber > 0
就没发现哪里不对 一直报')'附近有语法错误 郁闷死了 展开
展开全部
SELECT
TOP 10 *
FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY FILE_ARCNO DESC) AS rownumber,*
FROM
(
SELECT
*
FROM
ARC_FILE_ACC
WHERE
FILE_ARCNO = '11'
OR FILE_NO = '11'
OR TITLE = '11'
) AS t
) AS a
WHERE
rownumber > 0
TOP 10 *
FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY FILE_ARCNO DESC) AS rownumber,*
FROM
(
SELECT
*
FROM
ARC_FILE_ACC
WHERE
FILE_ARCNO = '11'
OR FILE_NO = '11'
OR TITLE = '11'
) AS t
) AS a
WHERE
rownumber > 0
追问
多谢大神，是不是每个子查询都得跟上as XXX?
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
