ALLInterview.com
Categories
|
Companies
|
Placement Papers
|
Code Snippets
|
Certifications
|
Visa Questions
Post Questions
|
Post Answers
|
My Panel
|
Search
|
Topics
|
Errors
vikam kumar
{ City } delhi
< Country > india
* Profession *
User No #
75632
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 / { vikam kumar }
Questions
Answers
Category
Views
Company
eMail
Answers / { vikam kumar }
Question
{
BirlaSoft
,
62098 }
Find out the 3rd highest salary?
Answer
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Is This Answer Correct ?
0 Yes
0 No