Interested to Buy Any Domain ? << Click Here >> for more details...
You have one employee table having 3 entries emp_id, Mgr_id
and salary. Mgr_id is also referencing emp_id. so now find
out the emp_id which are having the second highest salary,
under a particular manager.
- 3 Answers
- 8547 Views
- Amazon, HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar mrityunjay singh
SELECT *
FROM (SELECT EMPLOYEE_ID,MANAGER_ID,SALARY,DENSE_RANK() OVER(ORDER BY SALARY DESC)RN FROM EMPLOYEES WHERE MANAGER_ID='&ENTER_MANAGER_ID')WHERE RN < '&VALUE_UPTO'
/
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / rajesh
select * from (select
emp_id,mgr_id,salary,dense_rank()over(partition by mgr_id order by salary desc nulls last) rn from emp) where rn=2;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / chandra reddy
select empno,ename,deptno,sal from(select e.*,b.sal,rank()over(order by sal desc)send_h from em e join em1 b on e.empno=b.empno) where send_h=2
| Is This Answer Correct ? | 1 Yes | 1 No |
pls explain connect by prior with example and its real time use
is database gud carrier option??
How can I combine multiple rows into a comma-delimited list in oracle?
How to delete an existing row from a table in oracle?
Explain the family trees and connection by clause
how to clone 9i Database on to 10g Database.
what is the difference between substr and instr function in oracle?
What is the use of file param in imp command?
Which environment variables are absolutely critical in order to run the OUI?
What is index in Oracle?
Define oracle database
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
Oracle General 
