try:
SELECT TOP 1 * FROM <tablename>
It works fine with MS SQL Server (I think it doesn 't with Oracle)
Regards,
Martin
-----Original Message-----
From: PUB: Zhang, David [mailto:[EMAIL PROTECTED]]
Sent: Lunes, 09 de Abril de 2001 12:27 p.m.
To: [EMAIL PROTECTED]
Subject: Help: H0w to get frist row at SQl Server DB
Importance: High
HI, All
Help: H0w to get frist row at SQl Server DB
I have a huge table, but I only want to get the first row and I do not want
use
select * from Table to get WHOLE thing.
Thnaks a lot in advance!
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
