Re: Limiting the returning rows number of a SELECT

From: Richard Spee <rhpspee_at_wxs.nl>
Date: Mon, 3 Jun 2002 20:38:53 +0200
Message-ID: <adgdh3$d7v$1@reader05.wxs.nl>

Just make an inline view of your query.

select *
from (your query)
where rownum < &aRownum
/

"Paolo Quaglia" <paoloquaglia_at_hotmail.com> wrote in message news:adfrfu$4rri$1_at_stargate1.inet.it...
> Hi everyone,
> could you give me a fast advice on:
> - Limiting the number of returning rows of a select
>
> In Microsoft SQL, it exists the TOP that returns only the specified number
> of rows from a select
> in PostgreSQL it exists the LIMIT and OFFSET to do the job
>
> In Oracle?
>
> Thanks in advance to all
> Ciao
> Paolo
>
>
>
Received on Mon Jun 03 2002 - 13:38:53 CDT