Try this...
select * from test.table fetch first 10 rows only
Patrick Hans - Database Administration
State of Nebraska Department of Roads
Phone: 402.479.3987
E-mail: [EMAIL PROTECTED]
"Johnson, Shaunn"
<[EMAIL PROTECTED]> To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: DB2EUG: select limit
a.best.com
11/29/2001 04:13 PM
Please respond to
db2eug
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
