Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Is there any SQL(oracle) functions to get limited rows in select statement
Hi,
CAUTION : ROWNUM definetly limits the number of rows that is sent back from the database. But the downside of it is that the database scans ALL the rows in the table. If the table volume is high, then the performance impact would be significant...
In article <20000925160454.00893.00000923_at_ng-fp1.aol.com>,
raconrads_at_aol.com (Ra Conrads) wrote:
> >I have sql query which gives me certain number of rows, Is there any
way I
> >can write the query to and get only ceratin(lets say 50 or 100)
record back
>
> SELECT ROWNUM, ... your columns, ...
> FROM your table
> WHERE ROWNUM <= 50;
>
> Ralf Conrads
> E-Mail to: RaConrads_at_AOL.com
>
-- Regards Rajagopal Venkataramany Sent via Deja.com http://www.deja.com/ Before you buy.Received on Tue Sep 26 2000 - 22:31:28 CDT