Re: [DB2EUG] return limited amount of records

[Alejandro Daniel Toffetti]

       Yes, you should try:

select * from t_table fetch first NN rows only

or

select * from t_table fetch first row only

       if you want just one row returned.

Hpe this helps,

Daniel

Johnson, Shaunn wrote:

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



-
:::  When replying to the list, please use 'Reply-All' and make sure
:::  a copy goes to the list ([EMAIL PROTECTED]).
***  To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
***  For more information, check http://www.db2eug.uni.cc