I have this below Question:
List the details about employees who have maximum number of people reporting to them?
SELECT E.MGR, COUNT (*) FROM EMP E
GROUP BY E.MGR
HAVING COUNT (*) = (SELECT MAX (COUNT (*)) FROM EMP M GROUP BY M.MGR);
I am getting the o/p as below:
But i want to see all the employees data as well along with the reporting manager count, not able to get that..
please help on this, thanks in advance.