Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: limit
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