Re: Limiting number of returning rows

From: <nasof_at_hotmail.com>
Date: Wed, 22 Jul 1998 17:07:09 GMT
Message-ID: <6p567u$mq$1@nnrp1.dejanews.com>

Use:

...where rownum < x ...

ex:

select col1, col2, col3
from test_table
where rownum < 10;

-Frank

In article <6p4s77$j0p$1_at_nnrp1.dejanews.com>, john2335_at_my-dejanews.com wrote:
> Is there a syntax in oracle to limit number of returning rows
> in a single SQL call?
> I know you can do it in Sybase using: set row NUMBER_OF_ROW
>
> Tanks
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 22 1998 - 12:07:09 CDT