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: how to retrieve records from mth to nth rows in order form?

Re: how to retrieve records from mth to nth rows in order form?

From: Kari Marttila <Kari.Marttila_at_tieto.com>
Date: Mon, 27 Dec 1999 15:11:15 GMT
Message-ID: <3867816A.5439@tieto.com>


Hi!

Is there any way to do the same in previous versions of Oracle (Oracle 8.0.3)?

Thomas Kyte wrote:
> ...
> In Oracle8i, release 8.1 (and not before -- this query works in 8.1.5 and up)
> you can:
>
> select *
> from (select a.*, rownum R
> from ( select *
> from tablename
> order by whatever ) a
> where rownum <= MAX_ROW_YOU_WANT
> )
> where R >= MIN_ROW_YOU_WANT;
>

--
Kari Marttila Received on Mon Dec 27 1999 - 09:11:15 CST

Original text of this message

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