Skip to content

Instantly share code, notes, and snippets.

@markoradinovic

markoradinovic/gist:67e24b9c74a1a9b995c3

Created January 21, 2015 17:44
Show Gist options
  • Save markoradinovic/67e24b9c74a1a9b995c3 to your computer and use it in GitHub Desktop.
Save markoradinovic/67e24b9c74a1a9b995c3 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Paging
Raw
gistfile1.sql
select *
from ( select a.*, rownum rnum
from ( SELECT * FROM MAILBOX_MESSAGE order by MESSAGE_ID ) a
where rownum <= 10 )
where rnum >= 6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment