Execute the following script in Query Editor to filter the result set of a CTE by applying ROW_NUMBER():

USE AdventureWorks
GO
DECLARE @BeginRow INT, @EndRow INT
SET @BeginRow = 200
SET @EndRow = 280;

WITH ctePersonContact
AS
(SELECT FirstName, LastName, Phone, EmailAddress,
RowNumber = ROW_NUMBER() OVER(Order BY FirstName, LastName)
FROM Person.Contact)
SELECT [Name]=FirstName+' '+ LastName,
Phone,
EmailAddress,
RowNumber
FROM ctePersonContact
WHERE RowNumber >= @BeginRow
AND RowNumber <= @EndRow
ORDER BY [Name]
GO