Thanks but this does not suffice my reqmt... Thanks Ranjana
-----Original Message----- From: Seibert, Dave [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 7:18 PM To: [EMAIL PROTECTED] Subject: RE: DB2EUG: Fetch First n rows only ??? I believe you're looking for the row_number function. (Thanks to Terry Purcell for making me aware of this) Here's an example: select id,name , row_number( ) over () from staff David Seibert Compuware Corporation File-AID Product Architect [EMAIL PROTECTED] ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
