How to get Top 10 Salaries from a Table
Answer Posted / abirami
select max(salary) from tablename
fetch first 10 rows only
| Is This Answer Correct ? | 4 Yes | 25 No |
Post New Answer View All Answers
How to execute stored procedure in db2 command editor?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the clustering index in the db2 database?
What is the physical storage length of time data type?
Why do we use cursor?
What is the role of the data page in the db2 database?
How is a typical db2 batch pgm executed?
Comment whether the cursor is closed during commit or not.
What is page size in db2?
What do you mean by rollback?
What are host variables in db2?
Discuss about db2 bind?
What is db2 optimizer?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is iseries database?