FETCH a Specific Amount of Rows from Query
From: gilgantic <gilgantic_at_yahoo.com>
Date: 22 Apr 2003 09:42:08 -0700
Message-ID: <d6052717.0304220842.f348aac_at_posting.google.com>
Date: 22 Apr 2003 09:42:08 -0700
Message-ID: <d6052717.0304220842.f348aac_at_posting.google.com>
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!