Re: Best way to retrieve rows

Hi,

    You might try:

            SELECT * FROM <table> WHERE rownum < 21
            MINUS
            SELECT * FROM <table> WHERE rownum < 11;

regards

Jerry Gitomer

XU wrote in message <7j3p8q$f6v_at_gap.cco.caltech.edu>...
>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 Thu Jun 03 1999 - 14:06:33 CDT