Re: retrieving only n rows

From: Greg Vitetzakis <greg_at_ostnet.com>
Date: Thu, 22 Mar 2001 09:19:15 -0500
Message-ID: <3aba09c6@news1>

select * From SomeTable
where rownum <= 400;

Greg Vitetzakis

"Karol Brejna" <kazelot_at_thenut.eti.pg.gda.pl> wrote in message news:Pine.LNX.4.33.0103221214090.1931-100000_at_thenut.eti.pg.gda.pl...
> 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
>
>
Received on Thu Mar 22 2001 - 08:19:15 CST