Display those employees who are working as manager.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 608
SQL>SELECT M.ENAME MANAGER FROM EMP M ,EMP E
WHERE E.MGR=M.EMPNO GROUP BY M.ENAME

Comments or Responses

Login to post response