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, 24465 }

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