[DB2EUG] return limited amount of records

[Johnson, Shaunn]

Title: return limited amount of records

Howdy:

Is there a way to return only a limited amount
of records when running a query?

Example, in Oracle, I can:

[snip]

 select * from t_table where rownum < 10 ;

[/snip]

Is there something similar in DB2?

Thanks!

-X