How to get employee name from employee table which is the
fiveth highest salary of the table
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
Answer / naresh
select salary from (select distinct(salary) from employee
oraderby salary desc) where rownum<=5;
Is This Answer Correct ? | 2 Yes | 0 No |
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 |
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 |
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 |
what is msql? : Sql dba
What is flag in sql?
What is use of term?
What is a behavioral trigger?
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
What are basic techniques of indexing?
Can a key be both primary and foreign?
How do you declare a variable in pl sql?
What is the default value of CHAR type?
how to retrive only second row from table?
what is switch column,colums cost in oracle?
what are all the different normalizations? : Sql dba