Re: Limiting returned data from SQL Select Satement

From: Darryl Petruska <dkpetrus_at_data-insight.com>
Date: 1998/02/19
Message-ID: <6cidmg$i02@dfw-ixnews6.ix.netcom.com>#1/1

Another person gave you the warning about rownum and group by/order by. If you want the top ten values from a list ordered by field 'X' then perform the following query:

select *
from (select * from table_name order by x) where ROWNUM <= 10

Matthew Chappee wrote in message <34e9ae7c.229970109_at_ntserv02>...
>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
Received on Thu Feb 19 1998 - 00:00:00 CST