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 a file delimiter?
how to create a primary key with out creating an index?
What is schema in sql example?
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
Is sql a scripting language?
Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Who developed sql?
what are the demerits of sql?
How does stored procedure reduce network traffic?
If a cursor is open, how can we find in a pl/sql block?