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

Hi,

Yes there is a way.

select * from table
where rownum < 100;

Nevin
nhahn_at_evoke.com

kush <kdhakal_at_eline.com> wrote in message news:xw8w5.170$P35.6377_at_sjc-read...
> 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
>
>
Received on Thu Sep 14 2000 - 17:07:29 CDT