Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Is there any SQL(oracle) functions to get limited rows in select statement

Re: Is there any SQL(oracle) functions to get limited rows in select statement

From: Rajagopal Venkataramany <net_scan_at_my-deja.com>
Date: Wed, 27 Sep 2000 03:31:28 GMT
Message-ID: <8qrpmh$14k$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US