try
select top 1 * from table
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
Thomas McManus
Sent: 09 April 2001 17:28
To: [EMAIL PROTECTED]
Subject: Re: Help: H0w to get frist row at SQl Server DB
Does your SQL support a limit select statement?
(mySQL does) Try:
select * from Table limit x,y
where x = starting row (0 being the first row)
and y = the number of rows to return.
If so:
select * from Table limit 0,1
should return only the first row
-Tom
"Zhang, David" wrote:
> 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
===============================================================================
Traffic Interactive Limited
191 Old Marylebone Road
London
NW1 5DW
United Kingdom
Registered number: 3164767
Registered in England
Tel: +44 (0) 20 7298 8200
Fax: +44 (0) 20 7298 8201
This email its contents and any files or images with it are intended solely
for the addressee(s) and are confidential. If you have received this email
in error you may not copy or use the contents, attachments or information in
any way. Please destroy it and contact the sender on the number printed
above, via the Traffic Interactive switchboard or via email return.
DISCLAIMER
Material contained in this email may be copyright material of
Traffic Interactive or protected by other intellectual property rights. It
may only be reproduced with the express permission of Traffic Interactive.
Traffic Interactive does not accept responsibility for any changes made to
this email by unauthorised parties after it was sent. Whilst Traffic
Interactive runs antivirus software on all Internet emails it is not
liable for any loss or damage caused by an infected email. The recipient
is advised to run their own antivirus software. All information contained
in this email has been prepared using information believed by the author
to be reliable and accurate, but Traffic Interactive makes no warranty as
to accuracy and completeness. Any opinions expressed in this email are
those of the author and do not necessarily reflect the opinions of Traffic
Interactive or its affiliates.
===============================================================================
___________________________________________________________________________
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
