i have table agdet i want first 5 maximum commission which
query will you write for this thanks in advance
- 3 Answers
- 5602 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain in detail about buffer manager and its functionalities?
What is the latest version of ibm db2?
Can there be more than one cursor open for any program?
What is db2?
How connect db2 database to datastage?
What is dbrm? When it will be created?
What is ibm db2 client?
What is blu acceleration in db2?
How to find the number of rows in db2 tables?
How to retrieve rows from a db2 table in embedded sql?
What is the difference between plan and package in db2?
Who uses db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the information associated with sysibm.syslinks table?
