How to display those employees who are working in the same dept where his manager is work?

Oracle Apps Interview Questions › Category: SQL › How to display those employees who are working in the same dept where his manager is work?
0 Vote Up Vote Down
Questions Master asked 10 years ago

How to display those employees who are working in the same dept where his  manager is work?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

SELECT p.ename FROM emp e,emp p WHERE e.empno=p.mgr AND p.deptno=e.deptno;