Re: HELP Select only 1 Record
From: Roland Schaar <rschaar_at_gosch.com>
Date: Sat, 03 Jul 1999 20:48:44 +0200
Message-ID: <377E5B0C.8D0EF78F_at_gosch.com>
Date: Sat, 03 Jul 1999 20:48:44 +0200
Message-ID: <377E5B0C.8D0EF78F_at_gosch.com>
Charles Tasse wrote:
> I need to find a replacement for this SQL Statement
>
> Select TOP 1 Partnumber from Part.Master order by Partnumber Desc;
>
> i need the last number returned only
>
> Oracle 8
>
> Charles
Select TOP 1 Partnumber
from Part.Master
where rownum <= 1
order by Partnumber Desc;
roland Received on Sat Jul 03 1999 - 20:48:44 CEST