Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL:Only the last row of an result ?
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