Re: How to retrieve top 10 rows

On Thu, 17 Aug 2000 13:01:46 +1000, "Yulia" <yuliam_at_catuity.com> wrote:

>I do not know how to limit the number of rows
>returned by a query.
>In Sybase I could use "set rowcount 10".
>
>What does the same trick in Oracle?
>
>Yulia
>
>

Use rownum like this:

SELECT *
FROM TABLE
WHERE rownum <= 10    

Rui Anastácio Received on Thu Aug 17 2000 - 02:57:10 CDT