Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: NEWBIE: Limit Rows Returned by Select ?
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
![]() |
![]() |