Interested to Buy Any Domain ? << Click Here >> for more details...
i have table agdet i want first 5 maximum commission which
query will you write for this thanks in advance
- 3 Answers
- 6741 Views
- I also Faced
- E-Mail Answers
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 performance tuning db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What does db2 mean?
What is dbrm library?
What is the meaning concurrency in the db2 database?
What is the physical storage length of the data types date, time, and timestamp?
what is a corelated subquerry?
What is view db2?
How do I delete a table in db2?
What is copy pending and check pending in db2?
What is collection in db2 bind?
What is dclgen (declaration generator)?
Explain the contention situations caused by locks?
Can we update view in db2?
Define sqlca.
