Interested to Buy Any Domain ? << Click Here >> for more details...
How to get Top 10 Salaries from a Table
- 11 Answers
- 28473 Views
- Accenture, HTC, I also Faced
- E-Mail Answers
Answer Posted / meena dogra
The query will be like this:
Select distinct salary from table
order by salary desc
fetch first 10 rows only
| Is This Answer Correct ? | 31 Yes | 5 No |
Post New Answer View All Answers
How can the duplicate values be eliminated from db2 select?
Explain in brief how does db2 determine what lock-size to use?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Who uses db2?
What does runstats do in db2?
What is the usage of open cursor command?
What is node in db2?
How can you count the number of rows from a table tab?
Explain about cursor stability?
Which command is used to connect to a database in DB2 ? Give the Syntax.
On which levels locks can be applied?
What is temporal table in db2?
Explain correlated sub-queries.
What is a db2 schema?
How to find the maximum value in a column in the db2 database?
