Skip to content

Instantly share code, notes, and snippets.

@shammelburg

shammelburg/OFFSET_FETCH.sql

Created April 28, 2016 13:18
Show Gist options
  • Save shammelburg/7937ffdc14c0905398e4e5421b271d0e to your computer and use it in GitHub Desktop.
Save shammelburg/7937ffdc14c0905398e4e5421b271d0e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
OFFSET_FETCH.sql
select row_number() over (order by Name) as 'RowNUmber'
, Name
, ListPrice
from Production.Product
Order by Name
offset 20 rows
fetch next 10 rows only
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment