sql - TSQL - 无效的列名行号

Question

这个问题已经有答案了:

What is the order of execution for this SQL statement (8 个回答)

已关闭 9 年前。

为什么显示'Invalid Column Name'对于 WHERE 中的 RowNumber .

SELECT Id, Name,
ROW_NUMBER() OVER (ORDER BY Id) AS 'RowNumber'
FROM Folks
WHERE RowNumber=3

While 可以与 ORDER BY 一起使用

SELECT Id, Name
ROW_NUMBER() OVER (ORDER BY Id) AS 'RowNumber'
FROM Folks
ORDER BY RowNumber DESC

Answer 1

试试这个:

SELECT  *
FROM    (SELECT Id, Name,
                ROW_NUMBER() OVER (ORDER BY Id) AS 'RowNumber'
         FROM    Folks
        ) AS A
WHERE   RowNumber = 3