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
