how to find the fifth highest salary?
Answers were Sorted based on User's Feedback
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 |
Answer / soumen saha
select max(sal) from table where level=5 connect by prior
sal>sal;
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / saraswathi muthuraman
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 |
Answer / saraswathi muthuraman
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 |
Answer / nagireddy karri
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 |
Answer / arun
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 |
How do you communicate with an RDBMS?
What is the difference between stored procedures and stored functions in oracle?
What are data segments?
What is a Database system?
Name the sub-systems of a RDBMS?
What is the meaning of 3 tier?
What is a two tier wage system?
What is DML (Data Manipulation Language)?
What are page splits? : sql server architect
What is VDL (View Definition Language)?
waht is meant data independence?
State the different extensions for stored procedures?