我尝试选择表中的一些行 - 并得到错误

Question

我有表格，我用数字映射她。

我需要看到13排至20

我试试这个：

select Fname,Lname,rollet, 
ROW_NUMBER() OVER(ORDER BY rollet) AS RowID 
from BackUp2 
where RowID between 13 and 20 

和我得到这个错误：

Msg 207, Level 16, State 1, Line 5 
Invalid column name 'RowID'. 
Msg 207, Level 16, State 1, Line 5 
Invalid column name 'RowID'. 

我可以做什么？

Answer 1

select * 
from (select 
    Fname,Lname,rollet, 
ROW_NUMBER() OVER(ORDER BY rollet) AS RowID 
from BackUp2) xx 

where xx.RowID between 13 and 20