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