i have table agdet i want first 5 maximum commission which
query will you write for this thanks in advance

Answers were Sorted based on User's Feedback



i have table agdet i want first 5 maximum commission which query will you write for this thanks in..

Answer / 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

i have table agdet i want first 5 maximum commission which query will you write for this thanks in..

Answer / girish

select * from agdet a where 5 >= (select commission from
agdet a , agdet b where b.commission > = a. commission)with
ur;

Is This Answer Correct ?    0 Yes 3 No

i have table agdet i want first 5 maximum commission which query will you write for this thanks in..

Answer / thiru

select * from agdet order by commission fetch first 5 rows
only for read only with ur

Is This Answer Correct ?    3 Yes 7 No

Post New Answer

More DB2 Interview Questions

What is buffer pool?

0 Answers  


Are views updateable?

0 Answers  


Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  


how to check the table is empty or not?

3 Answers   IBM,


What is a host variable?

3 Answers  






Where would you find information about the type of database authority held by the user?

2 Answers  


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


What is ibm db2 client?

0 Answers  


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


How do I add a column to a table in db2?

0 Answers  


Mention the location where the output received from explain statement is stored.

0 Answers  


Can a Db2 table data be retrived through JCL?

4 Answers  


Categories