ALLInterview.com
Categories
|
Companies
|
Placement Papers
|
Code Snippets
|
Certifications
|
Visa Questions
Post Questions
|
Post Answers
|
My Panel
|
Search
|
Topics
|
Errors
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