Interview Questions Answers in DB2

sudhakar

{ City } kolkata
< Country > india
* Profession * mainframe professional
User No # 116060

Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { sudhakar }

Questions Answers Category Views Company eMail

Answers / { sudhakar }

Question { Accenture, 27631 }

How to get Top 10 Salaries from a Table

Answer

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