You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr

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.

Question Posted / prem

3 Answers
7201 Views
Amazon, HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing ..

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

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing ..

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

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing ..

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

Post New Answer