With
t
AS
(
SELECT contactid, namestyle, lastname,
ROW_NUMBER() over ( order by namestyle) as RowNumber
FROM Person.Contact
)
select * from t
Where RowNumber Between 20 and 30
(
SELECT contactid, namestyle, lastname,
ROW_NUMBER() over ( order by namestyle) as RowNumber
FROM Person.Contact
)
select * from t
Where RowNumber Between 20 and 30