Best way to retrieve rows

Hi, as we know that "select * from table_one where rownum <=10" will retrieve the first 10 rows of table_one, and "...where rownum <=20" will return the first 20 rows. But how about that I want to get the rows from 11 to 20 of table_one? Is it possible to retrieve an arbitrary portion of a table using rownum (NOT just first 10, first 100, etc., rows)? One possible solution I came up with is using "minus". For example, for the 11th to 20th rows of table_one:

select * from table_one where rownum <=20 minus
select * from table_one where rownum <=10

It seems to work but maybe there is a better solution? In general, this is a question of how to "page" through a large table - allow users to see the first 100 records, and then 101-200, 201-300, etc. Is rowid, sequence, ... going to be useful in this regard? Thanks.

Robert XU Received on Wed Jun 02 1999 - 12:22:34 CDT