How to get Top 10 Salaries from a Table
Answer Posted / abirami
Sorry.. Answer 1 given by me is incorrect.
Correct Query is
select disntinct salary from tablename
Order by salary
Fetch first 10 rows only
Is This Answer Correct ? | 9 Yes | 13 No |
Post New Answer View All Answers
What is a collection in db2?
What is with ur in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What are bind parameters in db2?
What is meant by explain?
What is iseries database?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is copy pending status in db2?
What is the role of the data page in the db2 database?
How do I start db2 in windows?
What is the maximum length of sqlca?
What does sqlcabc has?
What does reorg do in db2?
Explain db2.
What are the full forms of spufi and dclgen and why are they used?