how to find nth highest salary

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

Question Posted / mnggupta

103 Answers
178727 Views
Cognizant, IBM, NexGen, Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to find nth highest salary..

Answer / ganesh prasad

all are not working properly incase repeat salary
this one is correct to finding 4th highest salary try run
your system then call me 9438183722

select min(deptsal) from dept where deptsal in ( select
distinct top 4 deptsal from dept order by deptsal desc)

Is This Answer Correct ?

5 Yes

14 No

how to find nth highest salary..

Answer / sysdomain

'top' will fetch only top most : ie top 5 means it will
fetch first 5 rec. After fetching rec only 'order by' is
done ie sorting is done after fetching. therefore using
'top' and 'order by' alone wont get max or min value. for
that we have to use 'distinct' before 'top' (which will sort
the records before fetching).

select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc)

Is This Answer Correct ?

7 Yes

16 No

how to find nth highest salary..

Answer / saurabh

select max(salary) from Employee where salary not in (
select top 5 Salary from ( select distinct Salary from
Employee order by Salary desc))

Is This Answer Correct ?

0 Yes

11 No

how to find nth highest salary..

Answer / vijay dev arya

select salary from employee where salary>(select max
(salary) from employee)

Is This Answer Correct ?

6 Yes

17 No

how to find nth highest salary..

Answer / smitam

select top 1 salary from emp where (salary<(select max
(salary) from emp ))ORDER BY salary DESC

Is This Answer Correct ?

9 Yes

21 No

how to find nth highest salary..

Answer / vijay

select top 1 sal
from
(select top 3 sal
from emp
order by sal desc )sub
order by sal

Is This Answer Correct ?

12 Yes

24 No

how to find nth highest salary..

Answer / suhail qaiser

SELECT TOP Nth salary
FROM (
SELECT TOP N salary
FROM emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC

Is This Answer Correct ?

38 Yes

56 No

how to find nth highest salary..

Answer / pandian

select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a

Is This Answer Correct ?

65 Yes

88 No

how to find nth highest salary..

Answer / kavitha. r

select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc) order by
salary desc

Is This Answer Correct ?

12 Yes

40 No

how to find nth highest salary..

Answer / mayur

DECLARE @SQL VARCHAR(2000), @N INT
SET @N = 5
SET @N = @N - 1

SET @sql = 'select top 1 salary from ABC where salary not
in ( SELECT TOP ' + CAST(@n AS VARCHAR(100)) + ' salary
FROM ABC ) '

SELECT @SQL

EXEC (@SQL)

Is This Answer Correct ?

24 Yes

71 No

Post New Answer