Re: SELECT First(columnsname) from Tabel

From: Niall Litchfield <niall.litchfield_at_doial.pipex.com>
Date: 2000/06/23
Message-ID: <8ivv1c$b28$1@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...


> 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

>

>

>

Received on Fri Jun 23 2000 - 00:00:00 CDT