Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FETCH a Specific Amount of Rows from Query

Re: FETCH a Specific Amount of Rows from Query

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 22 Apr 2003 18:16:52 +0100
Message-ID: <3ea5b9c8_3@mk-nntp-1.news.uk.worldonline.com>


"gilgantic" <gilgantic_at_yahoo.com> wrote in message news: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.
>

select * from a where rownum < 11

By the way, I don't think there is a group called c.d.o - I believe it's a branch not a node. But in any event, people are generally discouraged from posting to multiple c.d.o. groups, since many folk read multiple groups. A courteous request to whichever group seems most appropriate will usually elicit a helpful response. Good luck!

Regards,
Paul Received on Tue Apr 22 2003 - 12:16:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US