None of these answers mentioned that you have to use an ORDER BY for the column that you want the top 10 values of; otherwise you will only get the first 10 and not the top 10.
> -----Original Message----- > From: Sinha, Abhijit [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 29, 2001 5:00 PM > To: [EMAIL PROTECTED] > Subject: RE: DB2EUG: select limit > > > select * from test.table fetch first 10 rows only > > -----Original Message----- > From: Johnson, Shaunn [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 29, 2001 5:14 PM > To: [EMAIL PROTECTED] > Subject: DB2EUG: select limit > > > > 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 > > > ===== > 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
