i have table agdet i want first 5 maximum commission which
query will you write for this thanks in advance
- 3 Answers
- 5539 Views
- I also Faced
- E-Mail Answers
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
If I have a view which is a join of two or more tables, can this view be updateable?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is view db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the result of open cursor statement?
What is the role of the data page in the db2 database?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Mention the location where the output received from explain statement is stored.
How to connect to db2 database from windows command line?
What do you mean by commit and rollback?
What is plan in cobol db2?
What is copy pending and check pending in db2?
What is host variable in db2 cobol?
Explain the contention situations caused by locks?
What is the difference between db2 and oracle?
