This article will show you how to page through a set of results using the OFFSET and FETCH options of the ORDER BY clause.
OFFSET
FETCH
ORDER BY