Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to retrieve rows
One more solution for the below query.
"select * from (select e.*,rownum p from emp e) where p between 5 and 8"
shailaja.
Jerry Gitomer <jgitomer_at_hbsrx.com> wrote in message
news:7j6jh1$ii3$1_at_autumn.news.rcn.net...
> 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 Tue Jun 15 1999 - 16:43:22 CDT