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 number of selected rows

Re: LIMIT number of selected rows

From: Georg Maaß <spam_at_clausmark.com>
Date: Wed, 21 Jan 2004 18:51:19 +0100
Message-ID: <bume0r$jpqiq$1@ID-3551.news.uni-berlin.de>


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

Original text of this message

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