Re: SQL Query

Actually it depends on what you mean by 'first' record...

The ..rownum < 2 will return the first record retrieved by the select statement ( after any where... and order by... statements have been processed) but that is not necessarily the 'first' record in the table..

Just my 2c
.
Andreas Michler <Andreas.Michler_at_adicom.de> wrote:

>select ............ where rownum < 2
>
>
>Kinna Patel wrote:
>
>> How can I write an SQL query which will return the first record in a
>> recordset. Under SQL Server 7 you can use the keyword TOP but this
>> does not work under Oracle.
>>
>> Thanks in advance

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Jan 27 2000 - 11:26:21 CST