How to get Top 10 Salaries from a Table
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
What is the purpose of rollback and commit?
How can you classify the locks in db2?
What is commit in db2?
What is the result of open cursor statement?
What is host variable?
How to check sequence on a table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to get the ddl of a table in db2?
What is buffer pool and list some of them?
What is sqlca?
What is a bind card?
How many databases are there?
What happens in bind step in a db2 program?
What is bufferpool in db2?
What is cursor in dbms?