RE: DB2EUG: select limit

[Ranjana Deshmukh]

Title: select limit

Please try this....

 

select * from test.table fetch first 10 rows only

 

 

 

Ranjana

 

 

-----Original Message-----
From: Johnson, Shaunn [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 3:44 AM
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