If you were to log in, you'd be able to get more information on your fellow community member.
And in PostgreSQL (and MySQL too for that matter) it is as simple as: select * from my_table order by my_id limit 90,10 An easier way for Oracle (according to a random post in a devshed.com forum I googled) would be like this: select * from my_table order by my_id where rownum between 90,100 (Though the whole point about how to use MINUS is well taken)
Oops. I was wrong. Phil emailed me and explained that my rownum example won't work (just goes to show that not everything you find on the internet is right!).