Re: FETCH a Specific Amount of Rows from Query

nearly the same

select * from TABLE where ROWNUM < 10

Olaf Raether

On 22 Apr 2003 09:42:08 -0700, gilgantic_at_yahoo.com (gilgantic) wrote:

>Hi,
>
>I know in DB2 you can use the FETCH keyword to get a specific amount of rows
>from a query. Example, SELECT * FROM A FETCH FIRST 10 ROWS ONLY, will return
>on the first 10 rows of a result set. How is this done in Oracle 8i., or is
>it even possible? The FETCH keyword is used differently in Oracle 8i as I
>understand it.
>
>Thanks!
>Gil
Received on Tue Apr 22 2003 - 12:42:48 CDT