Re: retrieving only n rows

On Thu, 22 Mar 2001 12:16:43 +0000, Karol Brejna <kazelot_at_thenut.eti.pg.gda.pl> wrote:

>I use Oracle 8.0.4.
>
>I have a select which gives me thousends of rows but
>only 4 houndred of them is significant to me.
>
>How can I tell Oracle to retrieve only 400 rows (and no more)?
>
>
>Thank you,
>Karol Brejna
>
>

try to insert the keyword ROWNUM in the WHERE clause in your select stmt, like the following:

SELECT ...
FROM ...
WHERE ROWNUM < 100

regards, nick Received on Thu Mar 22 2001 - 08:30:25 CST