Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL:Only the last row of an result ?

SQL:Only the last row of an result ?

From: Sven Kunze <svenkunze_at_aol.com>
Date: 1998/03/17
Message-ID: <1998031723004601.SAA20017@ladder01.news.aol.com>#1/1

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 Tue Mar 17 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US