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: select statement

Re: select statement

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Wed, 26 Jan 2000 02:43:41 +0200
Message-ID: <388E433D.D8896125@0800-einwahl.de>


I once saw something like

select ...
where rownum <= 20
minus
select ...
where rownum <= 10
/

Martin

Kathinka Diehl wrote:
>
> Vitek <victor_at_percombank.kiev.ua> schrieb:
> > select ...
> > where rownum<=10
>
> These are the first ten. Is there an easy possibility to get the next ten?
>
> Tia
> Kathinka
Received on Tue Jan 25 2000 - 18:43:41 CST

Original text of this message

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