Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: LIMIT number of selected rows
Bricklen wrote:
> select * from
> (select * from stuff order by some_criteria desc)
> where rownum = 1;
This is it. Thanks Received on Wed Jan 21 2004 - 11:51:19 CST
![]() |
![]() |