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 the difference between nvl and coalesce?
What is collection in db2 bind?
How to check table size in db2 sap?
What is package in cobol db2?
How to run db2 command in windows?
What is concurrency?
What is the role of data manager in the db2 database?
What is deadlock in db2?
How to rename a table in DB2 ?
What is dbrm? What it contains?
How connect db2 database to datastage?
Why do chiropractors use drop table?
What is explain plan in db2?
How and when does the db2 enforces the unique key?
What is difference between alias and synonym in db2?