shiva


{ City } lucknow
< Country > india
* Profession * software developer
User No # 101181
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 # 4
Users Marked my Answers as Wrong # 0
Questions / { shiva }
Questions Answers Category Views Company eMail




Answers / { shiva }

Question { IBM, 158931 }

how to find nth highest salary


Answer

SELECT MAX( salary) FROM salary where salary not in(
SELECT DISTINCT TOP 3 salary FROM salary order by salary desc)

Is This Answer Correct ?    4 Yes 0 No