Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: FETCH a Specific Amount of Rows from Query
Beware.... Hall monitors are out and about.
Paul Brewer wrote:
> "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 Wed Apr 23 2003 - 09:13:28 CDT