Display the employee name,job and his manager.Display also employee who are without manager?

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 1372
SQL>select e.ename,e.job,eMP.ename AS Manager from emp,emp e where
emp.empno(+)=e.mgr

Comments or Responses

Login to post response