Interested to Buy Any Domain ? << Click Here >> for more details...
How to get Top 10 Salaries from a Table
- 11 Answers
- 28146 Views
- Accenture, HTC, I also Faced
- E-Mail Answers
Answer Posted / sudhakar1.jha@gmail.com
SELECT Data.Amount FROM (
SELECT ROW_NUMBER() OVER(ORDER BY CUR_ANN_AMT DESC) AS RN,
Amount
FROM Employee_table) AS DATA
WHERE DATA.RN BETWEEN 1 AND 10 ;;;;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to find schema of a table in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the purpose of using commit?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is syscat in db2?
What does db2 mean?
Can there be more than one cursor open for any program?
What is data manager?
What's The Percentage Free Space ?
What is a db2 cursor?
How to take backup of table in db2?
How do you find the maximum value in a column in db2?
What is collection in db2 bind?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
