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
What is load replace in db2?
What is phantom read in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How to create backup table in db2?
How do I change the column size in db2?
What is db2 purescale?
Can you tell me how can you find out the # of rows updated after an update statement?
How to find the number of rows in db2 tables?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How to view db2 table structure?
What is a db2 schema?
How do we specify index to include or not during bind process.
What is db2 bind?
On which levels locks can be applied?
What is scrollable cursor in db2?