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: Limiting the returning rows number of a SELECT

Re: Limiting the returning rows number of a SELECT

From: Paolo Quaglia <paoloquaglia_at_hotmail.com>
Date: Mon, 3 Jun 2002 16:06:05 +0200
Message-ID: <adft4e$7trg$1@stargate1.inet.it>


Thanks Very Much!

"Peter Flunger" <p-i-b_at_gmx.at> ha scritto nel messaggio news:adfsgn$8kc$1_at_newsreader1.netway.at...
>
> "Paolo Quaglia" <paoloquaglia_at_hotmail.com> wrote
>
> > Hi everyone,
> > could you give me a fast advice on:
> > - Limiting the number of returning rows of a select
> >
> > In Oracle?
> >
> >
> If you don't do a sort via order by
> it is:
> where rownum < ( <desired-rows>+1 )
> or adding
> and rownum < ( <desired-rows>+1 ) to an
> existing where - clause.
>
> Peter
>
>
Received on Mon Jun 03 2002 - 09:06:05 CDT

Original text of this message

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