Re: Limiting returned data from SQL Select Satement

Use:

Select *
From emp
where ROWNUM <= 10;

• k7

In article <34e9ae7c.229970109_at_ntserv02>,   matthew_at_nospam.mattshouse.com wrote:
>
> Is there a way to limit the number of rows returned from an SQL Select
> statement? MS Access supported the following:
>
> Select Top 10 * from table_name
>
> I can't figure out the Oracle equivelant.
>
> Thanks,
>
> Matthew
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Feb 19 1998 - 00:00:00 CST