Hello Experts,
May I know that how can I display the manager who is having maximum number of employees working under him?
Kindly share your valuable views here,
Thanks in advance.
Jyoti Pandey || 16 Oct 2015 1:35 pm || 2
Hello Experts,
May I know that how can I display the manager who is having maximum number of employees working under him?
Kindly share your valuable views here,
Thanks in advance.
Comments
Recommended Posts:
SQL> select manager.ename from associate, manager
where manager.sal> (select avg(sal) from emp where
associate.mgr=manager.empno);