How to get employee name from employee table which is the fiveth highest salar

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

How to get employee name from employee table which is the
fiveth highest salary of the table

Question Posted / shivashanker

20 Answers
30082 Views
Infosys, Rolta, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / a g srikanth

Dear Shiv Shankar
There is a small mistake in your query

Select Salary From Employee a Where 5=(
Select Count(Distinct Salary) From Employee b
Where a.Salary <= b.Salary )

the correct one should be

Select Salary From Employee a Where 5=(
Select Count(Distinct Salary) From Employee b
Where a.Salary >= b.Salary )

please check it...

Is This Answer Correct ?

1 Yes

0 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / praveen

SELECT TOP 1 salary
FROM
(
select TOP 5 salary
FROM
employee
ORDER BY
salary DESC
) A
ORDER BY
salary

Is This Answer Correct ?

1 Yes

0 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / raghuvir

select * from employee where salary = (
select min(salary) from (
select distinct(salary) from employee
order by salary desc)
where rownum <=5)

Is This Answer Correct ?

1 Yes

0 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / ramu

select employee_name,salary from employee order by salary desc limit 1 offset 4;

Is This Answer Correct ?

1 Yes

0 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / vijay

select min(salary) from (select rownum r,e.* from employees e order by salary desc) where rownum<=5;

Is This Answer Correct ?

0 Yes

0 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / mrunali

select name from (select e.*, dense_rank() over (order by salary desc nulls last)as rn from emp e) where rn=5

Is This Answer Correct ?

0 Yes

0 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / raju t.t

select firt_name, salary from employees a where 5=(select
count(distinct salary from employees b where a.salary
<=b.salary);

Is This Answer Correct ?

6 Yes

7 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / anil alpati

SELECT employee_name FROM employee order by salary desc limit 1 offset 5 ;

Is This Answer Correct ?

0 Yes

1 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / anil alpati

Select empsal From emp order by empsal desc offset 5 limit 1;

Is This Answer Correct ?

0 Yes

3 No

How to get employee name from employee table which is the fiveth highest salary of the table..

Answer / shivashanker

Anybody knows the answer

Is This Answer Correct ?

1 Yes

6 No

Post New Answer