Write a code for fetching first 10 records starting with 50.
Now i decided to post it here for me and everyone else who may need it:
(You may run this query in AdventureWorks sample Database )
WITH Persons AS
(
SELECT FirstName,LastName,
ROW_NUMBER()
OVER (ORDER BY LastName) AS 'RowNumber'
FROM Person.Contact
)
SELECT FirstName,LastName
FROM Persons
WHERE RowNumber BETWEEN 50 AND 60;