Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to retrieve rows

Re: Best way to retrieve rows

From: shailaja <saila_at_irmac.com>
Date: Tue, 15 Jun 1999 16:43:22 -0500
Message-ID: <929482908.230.36@news.remarQ.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US