Re: SQL Query
From: <akats53_at_my-deja.com>
Date: 1999/10/07
Message-ID: <7tiqgd$4o5$1_at_nnrp1.deja.com>#1/1
Date: 1999/10/07
Message-ID: <7tiqgd$4o5$1_at_nnrp1.deja.com>#1/1
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 - 00:00:00 CEST