Hi,
Try,

select * from try fetch first 2 rows ONLY

Cheers,

Sudhir Shetty

-----Original Message-----
From: Amit Singal
[mailto:db2udbdba-ezmlmshield-x74815017.[Email address protected]
Sent: Tuesday, August 30, 2005 10:45 AM
To: LazyDBA Discussion
Subject: fetch row

select * from try fetch first 2 rows

I am getting following error while executing the query:

An unexpected token "END-OF-STATEMENT" was found following "y fetch
first 2
rows". Expected tokens may include: "ONLY".

Kindly Suggest the solution

Regards

Amit Singal





---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.

DB2 & UDB email list listserv db2-l LazyDBA home page