Re: Limiting the returning rows number of a SELECT

"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 - 08:55:34 CDT