i have table agdet i want first 5 maximum commission which
query will you write for this thanks in advance
Answer Posted / yuvaevergreen
exec sql
select commission from agdet order by commission desc
fetch first 5 rows only
end-exec;
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is ibm db2 connect?
What does a deadlock mean in DB2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
what is the responsibility of the construction superintendent
What is the role of union all and union
What is rct?
What is difference between alias and synonym in db2?
Why db2 is called db2?
What is the maximum length of sqlca?
What is bind package and plan in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is an instance in db2?
What is a cursor in programming?
How can you do the explain of a dynamic sql statement?
What is the difference between plan and package in db2?