Oracle SQL Forum
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.
SQL> select manager.ename from associate, managerwhere manager.sal> (select avg(sal) from emp whereassociate.mgr=manager.empno);
select mgr,count(empno) as total_employees from emp group by mgrhaving count(empno)=(select max(count(empno))from emp group by mgr);
Sign up for STechies