Re: SELECT First(columnsname) from Tabel
From: Niall Litchfield <niall.litchfield_at_doial.pipex.com>
Date: 2000/06/23
Message-ID: <8ivv1c$b28$1_at_soap.pipex.net>#1/1
Date: 2000/06/23
Message-ID: <8ivv1c$b28$1_at_soap.pipex.net>#1/1
as first just returns the first record of a recordset this is equivalent to
select (whatever) from table
where rownum = 1;
-- Niall Litchfield Oracle DBA Audit Commission UK "Nijntje" <NO_SPAMavanrossem_at_hotmail.com> wrote in message news:8itadh$l2v$1_at_nereid.worldonline.nl...Received on Fri Jun 23 2000 - 00:00:00 CEST
> In MS-Access i can use the select first( - statement (SELECT
> First(columnsname) from Tabel)
>
> How can i do it in Oracle ???
>
> Thank u all very much,
> Andre van Rossem
> The Netherlands
>
>
>