How to display those employees who are working in the same dept where his manager is work?
SELECT p.ename FROM emp e,emp p WHERE e.empno=p.mgr AND p.deptno=e.deptno;