find the 3rd max salary

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / akthar2272

10 Answers
8902 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

find the 3rd max salary..

Answer / udaya

select emp_salary from emp e where 3 =(select count(distinct
emp_salary) from emp where e.emp_salary<=emp_salary)

Is This Answer Correct ?

11 Yes

3 No

find the 3rd max salary..

Answer / neetu

Select Top 1 Salary from TableName where Salary IN(select
top 3 salary from TableName order by salary Desc) order by Asc

Is This Answer Correct ?

6 Yes

1 No

find the 3rd max salary..

Answer / cpnagar

select top 1 salary from(select distinct top 3 salary from
emp order by salary desc)as e order by e.salary

Is This Answer Correct ?

7 Yes

4 No

find the 3rd max salary..

Answer / kk

select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc

Is This Answer Correct ?

1 Yes

0 No

find the 3rd max salary..

Answer / rajasekar

er
# 9
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc

Is This Answer Correct ?

0 Yes

0 No

find the 3rd max salary..

Answer / cpnagar

SELECT salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY
salary desc) AS RN,*
FROM
emp)temp
WHERE
RN=3

Is This Answer Correct ?

2 Yes

3 No

find the 3rd max salary..

Answer / karthik

select min(salary) from (select top 3 * from employee order by salary desc) temp

Is This Answer Correct ?

0 Yes

1 No

find the 3rd max salary..

Answer / vasanth

SELECT min(Salary)
FROM (SELECT TOP 3 Salary FROM dbo.tblPopulation
GROUP BY [Population (in Millions)]
ORDER BY [Population (in Millions)] DESC ) TEMP

Is This Answer Correct ?

0 Yes

1 No

find the 3rd max salary..

Answer / vaishnavi nigam

SELECT Salary from Emp_sal ORDER BY Salary Desc WHERE Row_Num=3

Is This Answer Correct ?

0 Yes

1 No

find the 3rd max salary..

Answer / shruti

select salary from salarytable orderby salary desc Limit 2,1

First It will arrange all salary in desc order then it will
limit the result using Limit command starting from position
0,1,2 and fetch record 1

Is This Answer Correct ?

0 Yes

2 No

Post New Answer