Find out the number of employees whose salary is greater than their manager salary?

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 2085
SQL>SELECT E.ENAME FROM EMP ,EMP E WHERE EMP.EMPNO=E.MGR
AND EMP.SAL<E.SAL;

Comments or Responses

Login to post response