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 / 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 |
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 |
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 |
Answer / ramu
select employee_name,salary from employee order by salary desc limit 1 offset 4;
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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 |
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 |
Answer / anil alpati
SELECT employee_name FROM employee order by salary desc limit 1 offset 5 ;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anil alpati
Select empsal From emp order by empsal desc offset 5 limit 1;
Is This Answer Correct ? | 0 Yes | 3 No |
How can get second highest salary in sql?
What is a cursor for loop ?
what is a primary key? : Sql dba
what is oracle sql,pl/sql with interfaces
What is a dirty read sql?
What is the clause we need to add in function body to return variable?
what is difference between stored procedures and application procedures,stored function and application function?
What is the difference between microsoft access and sql?
What is lookup table in sql?
how to get second highest salary in SQL(as/4000
How do temporal tables work?
Why partition by is used in sql?