i have table that i map her with numbers.
i need to see rows from 13 to 20
i try this:
select Fname,Lname,rollet,
ROW_NUMBER() OVER(ORDER BY rollet) AS RowID
from BackUp2
where RowID between 13 and 20
and i get this error:
Msg 207, Level 16, State 1, L开发者_StackOverflowine 5
Invalid column name 'RowID'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'RowID'.
what i can do ?
select *
from ( select
Fname,Lname,rollet,
ROW_NUMBER() OVER(ORDER BY rollet) AS RowID
from BackUp2 ) xx
where xx.RowID between 13 and 20
精彩评论