RE: [DB2EUG] return limited amount of records

[Ioffe, Dimitry]

Title: Message

select * from t_table fetch first 10 rows only

 

under full select --> fetch-first-clause in manuals.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Johnson, Shaunn
Sent: Tuesday, January 20, 2004 10:50 AM
To: [EMAIL PROTECTED]
Subject: [DB2EUG] 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