Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting the returning rows number of a SELECT
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
![]() |
![]() |