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
- 6734 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
Please Help Members By Posting Answers For Below Questions
Define data page.
What is null in db2?
What is bind in db2?
What is coalesce in db2?
What is query_cache_limit?
What is copy pending status in db2?
What happens in bind step in a db2 program?
When the like statement is used?
How to find the number of rows in a db2 table?
Is db2 free?
What is alias in db2?
What is the syntax for creating a table in the db2 database?
What does a deadlock mean in DB2?
What is concurrency?
What is a db2 package?
