How to find 6th highest salary from Employee table ?

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

Question Posted / saravakumar

10 Answers
24394 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to find 6th highest salary from Employee table ?..

Answer / saravakumar

SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 6 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary

Is This Answer Correct ?

30 Yes

8 No

How to find 6th highest salary from Employee table ?..

Answer / answer

SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 6 MAX (SALARY) FROM EMPLOYEE ORDER BY SALARY
DESC)

Is This Answer Correct ?

16 Yes

4 No

How to find 6th highest salary from Employee table ?..

Answer / rahul gupta

select sal from employee e1 where 5 = (select count(*) from
employee e2 where e1.sal < e2.sal)

Is This Answer Correct ?

5 Yes

2 No

How to find 6th highest salary from Employee table ?..

Answer / lince thomas

select salary from(
select row_number() over(order by salary desc) as rno,*
from Employee)T where T.rno=6

Is This Answer Correct ?

3 Yes

0 No

How to find 6th highest salary from Employee table ?..

Answer / lince

select * from(select salary,dense_rank() over(order by salary desc) as rno from emp)T where T.rno=6

Is This Answer Correct ?

2 Yes

0 No

How to find 6th highest salary from Employee table ?..

Answer / anto

select distinct top6 salary from employee

Is This Answer Correct ?

2 Yes

2 No

How to find 6th highest salary from Employee table ?..

Answer / vj

with cte as
(
select dense_rank() over (order by salary desc)
maxSal ,* from Employee )
select * from cte where maxSal=6

Is This Answer Correct ?

0 Yes

0 No

How to find 6th highest salary from Employee table ?..

Answer / maheswar reddy s

select * from Employee e1 where 6=(select count(distinct(salary))from employee e2 where
e2.salary>=e1.salary)

Is This Answer Correct ?

0 Yes

0 No

How to find 6th highest salary from Employee table ?..

Answer / krishan kant

SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 6 SALARY FROM EMPLOYEE ORDER BY SALARY
DESC)

Is This Answer Correct ?

0 Yes

0 No

How to find 6th highest salary from Employee table ?..

Answer / manikanta

select min(salary) as salary from Employee where salary >
(select min(salary)from employee)

Is This Answer Correct ?

1 Yes

4 No

Post New Answer