write query for fourth maximum salary from employee table

Question Posted / k l baiju

14 Answers
22006 Views
Mind Tree, SP Software, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write query for fourth maximum salary from employee table..

Answer / anish tuladhar

select
distinct salary
from
(
select
DENSE_RANK() over(order by salary desc) as rnk,
salary
from
employee
) a
where
rnk = 4

Is This Answer Correct ?

0 Yes

0 No

write query for fourth maximum salary from employee table..

Answer / prabhjeet singh sethi

select * from
(select rank(salary) over (partition by employee order by salary desc) as top_salary, employee from table
group by employee)
where top_salary = 4

Is This Answer Correct ?

0 Yes

0 No

write query for fourth maximum salary from employee table..

Answer / icedrop

select top 1 salary from (select distinct top 4 Salary from tablename order by salary desc ) result order by salary

Is This Answer Correct ?

0 Yes

0 No

write query for fourth maximum salary from employee table..

Answer / santhosh

;with result as
(
--use dense_rank instead of row_number or rank
select salary, DENSE_RANK() over (order by salary desc) as denserank
from Employees
)
select top 1 * from result
where denserank = 4

Is This Answer Correct ?

0 Yes

0 No

Post New Answer