How to get Top 10 Salaries from a Table
Answers were Sorted based on User's Feedback
Answer / abirami
select max(salary) from tablename
fetch first 10 rows only
| Is This Answer Correct ? | 4 Yes | 25 No |
What are the advantages of using a PACKAGE?
Can we delete records from view?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is a view? Why use it?
What does the CHECK Utility do ?
How to resolve -502 sql code in DB2?
Where besides the DB2 catalog is database object information stored by DB2?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Are view updateable?
List out the three types of page locks that can be held.
Differentiate between cs and rr isolation levels? Where do you specify them?
What is cursor?