Hello Firat,
Tuesday, April 10, 2001, 1:38:03 PM, you wrote:
FT> select * from Table LIMIT 0, 1 ---->1st row,
FT> select * from Table LIMIT 0, 2 ---->1st and 2nd row, etc, etc, bla bla
Hm, it works in MySQL, what about M$$ql?
FT> ----- Original Message -----
FT> From: "Zhang, David" <[EMAIL PROTECTED]>
FT> To: <[EMAIL PROTECTED]>
FT> Sent: Monday, April 09, 2001 6:27 PM
FT> Subject: Help: H0w to get frist row at SQl Server DB
>> 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
FT> want
>> use
>> select * from Table to get WHOLE thing.
>> Thnaks a lot in advance!
>>
>>
FT> ___________________________________________________________________________
>> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
FT> 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
>>
FT> ___________________________________________________________________________
FT> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
FT> of the message "signoff SERVLET-INTEREST".
FT> Archives: http://archives.java.sun.com/archives/servlet-interest.html
FT> Resources: http://java.sun.com/products/servlet/external-resources.html
FT> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
--
Alexander Fedorov
Software developer
Adcore
Wibautstraat 120
1091 GP Amsterdam
the Netherlands
tel: +31 (0)20 561 1825
fax: +31 (0)20 5611701 or +31 (0)20 5611849
e-mail: mailto:[EMAIL PROTECTED]
www.adcore.nl
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6
mQEPAzp+jaIAAAEIAKB37EITxsVevyCDd9hOmtLhyzncJZ94UIhi/yflAk8c3xr+
1lFkXpXrs7PhmzTzzojmJQulUIBwV8IHVi3P3sua4PpcRWtAzbGfP4G4rsGcBKdi
09xkELSEtfICsBU3/haQQIB2UH/T/zAefFaRj3XRI/Mqwhz1v6uqwy3zWtKpJWVE
RpeA6ShMd+w7Gp5NvsomUjEpZRIZLWBHpcbjsn34A1VLUMw272e2o9ndV91nDcFf
SFZQpNCUdhM7eM9x4ab6pIrLkWlvDehQnBAyXs95Zxviwhmd37fBWM4MA3V9GsLv
ZxJ1WmmPyu4Hv/7tTYNDSlODHYU5jIZg+jBbvJUAEQEAAbQwQWxleGFuZGVyIEZl
ZG9yb3YgPGFsZXhhbmRlci5mZWRvcm92QGFkY29yZS5jb20+
=Ak1z
-----END PGP PUBLIC KEY BLOCK-----
___________________________________________________________________________
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