How to Display the Manager, Having Maximum Number of Employee?

Answered

By: Jyoti Pandey | 16 Oct 2015 1:35 pm | 2 Comments

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

Abhijeet Mudgal |

| 16 Oct 2015 2:15 pm

Helpful answer

SQL> select manager.ename from associate, manager
where manager.sal> (select avg(sal) from emp where
associate.mgr=manager.empno);

Sugandh |

| 16 Oct 2015 2:16 pm

Helpful answer

select mgr,count(empno) as total_employees from emp group by mgr
having count(empno)=(select max(count(empno))from emp group by mgr);

How to See All the Employees Data as well along with Reporting Manager Count?
Hello Experts,I have this below Question:List the details about employees who have maximum number of people reporting to them?SQL>Â SELECT E.MGR, COUNT (*) FROM EMP EGROUP BY E.MGRHAVING COUNT...
Oracle SQL optimization Interview Questions and Answers
Q1. What is SQL optimization?Ans: SQL optimization (or SQL statement tuning or Shared Cursor cache analysis) refers to the identification, analysis and optimization of SQL statements that are...
Duplication of Employee Data
How to deal with the following scenario: Data entered in IT0002 for one employee number is getting saved for two employee's at the same time (employee number whom the data was entered and...
Maximum number of input lines for actual postings
Explanation:The total of line items (COEP + COEPL for KB11(N), KB15(N), KB21(N), KB41(N), KB51(N) and/or COEPR for KB31(N)) is limited to 999. For Transactions KBxx (xx = 11, 15, 21, 31, 41, and 51)...

Get solutions from our experts!