Interested to Buy Any Domain ? << Click Here >> for more details...
How to get Top 10 Salaries from a Table
- 11 Answers
- 28480 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
What is db2 command?
What is the reason behind not using select * in embedded sql programs?
Is schema the same as database?
What is null value in db2?
How to find the number of rows in a db2 table?
What is bind plan?
What is an instance in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is a db2 cursor?
What is page size in db2?
Why db2 is called db2?
What does db2 blu stand for?
What is the difference between cursor stability and repeatable read isolation levels?
What is sqlca’s maximum length?
What are bind parameters in db2?
