Display the name of the department where no employee working.

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

Comments or Responses

Login to post response