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

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: 1998/03/18
Message-ID: <01bd5265$7796fbc0$73d0658c@ukmhdam>#1/1

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 Wed Mar 18 1998 - 00:00:00 CST