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 Wait Events Interview Questions and Answers
FAQ: Oracle/ SQL Wait Events1. What are wait events?Wait events are characteristic parts of the Oracle kernel source code that can contain Oracle sessions during execution. Oracle provides...
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...
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...

Get solutions from our experts!