Try this:
select * from test.table fetch first 10 rows only Amir >From: "Johnson, Shaunn" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: DB2EUG: select limit >Date: Thu, 29 Nov 2001 17:13:54 -0500 > >Howdy: > >I'm sure there is a way to do this, but I >don't know *how* ... > >How do you get the top 10 (or, whatever number) >records via the command line in DB2? > >On some other DB apps, there is a limit function >that allows you to do something like: > >[snip] > >database=> select * from test.table limit 10 > >[/snip] > > >This gets me the first 10 records. How can I do >this in DB2? > >TIA. > >-X _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
