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

Home -> Community -> Usenet -> c.d.o.misc -> Re: limit

Re: limit

From: Michael L. Hostbaek <michDEL_THIS_at_bsd.fr.eu.org>
Date: 22 Jan 2002 15:17:31 GMT
Message-ID: <slrna4r0fh.1nbn.michDEL_THIS@freebsdcluster.dk>


Michael L. Hostbaek tried to tell us something, and all I got was:
> Hello,
>
> from old mySQL usage, I seem to remeber that an output limit was
> possible in conjunction with the SELECT statement.. How would one go
> about that with Oracle/SQL ?
>

Just to clearify, I *am* aware of the 'numrow' function. But I cannot use 'numrow' together with 'order by' or 'asc/desc'

Let us say I would like the ten last rows of a table - how would I do that ?

-- 
Regards,
Michael L. Hostbaek
-= So long, and thanks for all the fish.. =-
Received on Tue Jan 22 2002 - 09:17:31 CST

Original text of this message

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