Gabriel Ricard

A member of the Philip Greenspun's Homepage community since February 26, 2003

If you were to log in, you'd be able to get more information on your fellow community member.

February 26, 2003, on Complex Queries:
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)
March 17, 2003, on Complex Queries:
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!).