Skip to content

Instantly share code, notes, and snippets.

@fecub

fecub/select_range_of_items

Created June 24, 2015 11:43
Show Gist options
  • Save fecub/3ecfca8a36c3e55bc143 to your computer and use it in GitHub Desktop.
Save fecub/3ecfca8a36c3e55bc143 to your computer and use it in GitHub Desktop.
Download ZIP
SELECT range of item
Raw
select_range_of_items
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY lAG_ID ASC) AS rownumber,
*
FROM CP_Einzelauftrag
) AS foo
WHERE rownumber >= 6 AND rownumber <= 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment