i have table agdet i want first 5 maximum commission which
query will you write for this thanks in advance
Answer Posted / 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 |
Post New Answer View All Answers
Name the lockable units in DB2?
What is bind plan?
How do I delete a column in db2?
How do I add a column in db2?
What does runstats do in db2?
How do I delete a table in database?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is table space in db2?
i want to maintain uniqueness on pdf without make lf??????????
Explain various types of locks in db2?
What is cursor in dbms?
How to find primary key of a table in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is bind package and plan in db2?
What is netezza database?