Re: SQL:Only the last row of an result ?

From: ALEX J JENTILUCCI <ALEXJENT_at_prodigy.net>
Date: 1998/03/19
Message-ID: <6esprk$4ubi$1@newssvr03-int.news.prodigy.com>#1/1

Add to the previous response:

            Select * from Table1
            where Col1 = 'Test'
            and rownum =1
            order by Col1 DESC

Alex

Alan D. Mills wrote in message <01bd5265$7796fbc0$73d0658c_at_ukmhdam>...
>
>Select * from Table1 where Col1 = 'Test' order by Col1 DESC
>
>to reverse the order. then just look at the first row.
>
>--
>Alan D. Mills
>
>To email remove NOSPAM from address.
>
>Sven Kunze <svenkunze_at_aol.com> wrote in article
><1998031723004601.SAA20017_at_ladder01.news.aol.com>...
>> Is there a way to get only the last row of a result set.
>>
>> For example:
>>
>> Select * from Table1 where Col1 = 'Test' order by Col1
>>
>> I just need the last record, but using the MoveLast-command in visual
Basic is
>> VERY slow.
>> Sven Kunze.
>>
>> I use ORACLE 8.0.3.0.0 on NT Server 4.0 (SP3), TCP/IP, and Client NT 4.0
(SP3)
>> with Access 2.0 / 97 / Visual Basic 4.0 *(16-Bit) and ODBC 8.0.3.0.0
32-Bit.
>>
>>
Received on Thu Mar 19 1998 - 00:00:00 CST