How to get Top 10 Salaries from a Table
Answer Posted / regu
select distinct salary from table name hwre rownum <=10
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How do I copy a table in db2?
How do I add a column in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is access path in db2?
What is package in cobol db2?
If I have a view which is a join of two or more tables, can this view be updateable?
How do I add a column to a table in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is dbrm? What it contains? When it will be created?
Explain what are the various isolation levels possible?
What is the role of the data page in the db2 database?
What are the full forms of spufi and dclgen and why are they used?
What are foreign keys in db2?
What is database reorganization?