how to find the number of employees under each manager
755220Feb 21 2010 — edited Feb 21 2010hi all,
i am trying to this query
select a.empno,a.empno,a.ename,a1.ename from emp a,emp a1
where a.mgr=a1.empno
this query returns each employee and their manager name
my request is
how to count the number of employees under each manager