Title: 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

Reply via email to