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
25980 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 / m haribaskar

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

Is This Answer Correct ?

25 Yes

7 No

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

Answer / kishore

select salery from (
(select salery ,rownum as num from
(select salery from employees order by salery desc)
where rownum <= 5 ))
where num = 5;

Is This Answer Correct ?

18 Yes

4 No

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

Answer / kavitha nedigunta

select a.ename,a.sal
from(select ename,sal,
dense_rank() over( order by sal desc nulls last) rk
from emp)a
where rk =5;

Is This Answer Correct ?

7 Yes

1 No

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

Answer / shashidhar

SELECT EMP_NAME (SELECT ROWNUM R,B.* FROM employee B ORDER
BY SALARY DESC) A
WHERE A.R = 5

Is This Answer Correct ?

4 Yes

1 No

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

Answer / ashwin

Hi, you can use following query.

select ename,sal from(select ename,sal from emp order by sal
desc)where rownum=5;

Is This Answer Correct ?

5 Yes

2 No

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

Answer / ajeet

SELECT first_name, salary FROM employees E1
WHERE (3) > (SELECT COUNT(DISTINCT(E2.salary))
FROM employees E2
WHERE E1.salary > E2.salary)

Is This Answer Correct ?

3 Yes

1 No

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

Answer / naresh

select salary from (select distinct(salary) from employee
oraderby salary desc) where rownum<=5;

Is This Answer Correct ?

2 Yes

0 No

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

Answer / ajeet

SELECT first_name, salary FROM employees E1
WHERE (5) = (SELECT COUNT(DISTINCT(E2.salary))
FROM employees E2
WHERE E1.salary < E2.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 / mani

select first_name,sal from
(
select first_name,sal from
(
select distinct
sal from employees
order by sal desc
)
where rownum < 5
order by sal
)
where rownum<2;

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 / avi007

SELECT employee_name,min(salary) FROM ( select distinct
salary from employee order by salary desc)
where rowno<6 group by employee_name;

Is This Answer Correct ?

2 Yes

1 No

Post New Answer