Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to retrieve records from mth to nth rows in order form?
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