MVSFORUMS.com

[salimo]

Any help with how to accomplish getting the TOP 10 rows
from any Table in DB2 SQL, using SPUFI.
I've read the DB2 SQL manual, and it talks about OPTIMIZE FOR, but thats for embedded code.

I cannot find an equivalent DB2 SQL Function for TOP 10

Any thoughts on a select as:

Select TOP 10 MAX(Salary), Emp_name ?
Thank you.

[kolusu]

Salimo,

Please searh before posting. This topic has been discussed earlier and here is the link

http://www.mvsforums.com/helpboards/viewtopic.php?t=23&highlight=salary

Hope this helps..

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[salimo]

Thank you Kolusu,

I totally missed the SEARCH ENGINE is a terrible thing to waste.
I will use it before posting.
Thanks again.