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

Home -> Community -> Usenet -> c.d.o.tools -> Re: NEWBIE: Limit Rows Returned by Select ?

Re: NEWBIE: Limit Rows Returned by Select ?

From: Jeremy Beal <jbeal_at_jbeal.org>
Date: Mon, 09 Oct 2000 21:51:33 GMT
Message-ID: <39e23dca.31741972@News.ai.com>

On Mon, 09 Oct 2000 13:52:07 +0100, Steve Cholerton <stevechol_at_freeuk.com> wrote:

>Thanks for the response, but I am looking for the LAST 2000 records in
>the order of the primary key descending, in this case I do not know
>the rownum (how can I find the last rownum?)

I guess you could do a select count(*) first... Received on Mon Oct 09 2000 - 16:51:33 CDT

Original text of this message

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