Re: SELECT First(columnsname) from Tabel

If Access uses 'first' to mean the highest, then in Oracle ( and Standard SQL)

use
select max(columnsname)...

"Nijntje" <NO_SPAMavanrossem_at_hotmail.com> wrote:

>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
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Jun 22 2000 - 00:00:00 CDT