Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Query
In article <37FCCD3C.6B0024E9_at_mci.com>,
George Wilson Mathias <george.mathias_at_mci.com> wrote:
> Hello there,
>
> How can I select batch of rows from a table ? I mean If I a table with
> 1000 rows, how can I selects rows from 100 to 200 or 500 to 600 ?
>
> Thanks
> George Mathias
George, you can do it with
select * from emp where rownum<100
minus
select * from emp where rownum<80
/
Regards, Arkady
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Oct 07 1999 - 13:58:29 CDT