Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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