how to find the fifth highest salary?

Answers were Sorted based on User's Feedback

how to find the fifth highest salary?..

Assuming that EMP table with Sal column

SELECT MIN(sal) FROM
(SELECT DISTINCT sal FROM emp WHERE
ROWNUM < 6
ORDER BY sal DESC )

- If fifth highest then ROWNUM < 6
- If n'th highest then ROWNUM < n+1

Regards
J

 Is This Answer Correct ? 11 Yes 5 No

how to find the fifth highest salary?..

select max(sal) from table where level=5 connect by prior
sal>sal;

 Is This Answer Correct ? 5 Yes 2 No

how to find the fifth highest salary?..

SQL> select * from emp_test order by sal desc;

1003 20010 11
1001 10000 11
1001 10000 11
1002 100 11
1004 99 11
1005 50 11
1006 25 11

SQL> select * from (select emp_no,dep_no,sal,rank() over
(order by sal desc) as rank_list from emp_test) where
rank_list =5;

1004 11 99 5

 Is This Answer Correct ? 5 Yes 5 No

how to find the fifth highest salary?..

Try this :

SQL> select * from (select emp_no,dep_no,sal,rank() over
(order by sal desc) as rank_list from emp_test group by
emp_no,dep_no,sal) where rank_list =5;

1005 11 50 5

This seems to be a correct answer if few employ having same sal

 Is This Answer Correct ? 2 Yes 2 No

how to find the fifth highest salary?..

SELECT MIN(SAL) FROM(SELECT TOP 5 * FROM EMP ORDER BY SAL
DESC) AS MIN_SAL

 Is This Answer Correct ? 1 Yes 2 No

how to find the fifth highest salary?..

select min(emp_sal) from (select (Emp_sal) from(select
Emp_sal from emp order by emp_sal desc) and rownum<=5)

 Is This Answer Correct ? 0 Yes 1 No

how to find the fifth highest salary?..

select MIN(salary) from (select distinct salary from employees
order by salary desc) where ROWNUM < 6 ;

ITS SELECTING from employees table 5th highest salary

 Is This Answer Correct ? 3 Yes 5 No

how to find the fifth highest salary?..

Select max(Employee_Sal) From Employee where Employee_Code
in(Select Top 5 Employee_Code,Employee_Name,Employee_Sal
From Employee Order by Employee_sal desc)

 Is This Answer Correct ? 1 Yes 3 No

More DB Architecture Interview Questions

What is DML (Data Manipulation Language)?

What is E-R model?

What is VDL (View Definition Language)?

What is meant by query optimization?

Which is super key?

Explain the truncate command? : sql server architect

State about the security aspects of stored procedures?

What is a two tier wage system?

What is external database?

What does n tier mean?

What is internal database?

What is the difference between layer and tier?

Categories