Find the count of all the managers in the database

suppose you need to find distinct managers from both the Employees and Departments tables. In that case, you should combine the manager_id from the Employees table and the manager_id from the Departments table then use UNION to merge distinct manager_id values from both tables.Here is the query:

SELECT COUNT(DISTINCT manager_id) AS TotalManagers
FROM (
    SELECT manager_id FROM Employees WHERE manager_id IS NOT NULL
    UNION
    SELECT manager_id FROM Departments WHERE manager_id IS NOT NULL
) AS CombinedManagers;

This query gives the total count of unique managers across both Employees and Departments tables.

yes unique records can be found in employee table but need to find the distinct managers from employee and departments tables

so do I need to join the tables of both and filter based on departmentId or managerid matching

As the structure diagram, manager_id column exists in the Employees table (indicating that each employee has a manager, except for top-level managers who have NULL), you can find the total number of unique managers in the database using the COUNT(DISTINCT manager_id) function.

-- SQL Query to Find the Total Count of Managers:
SELECT COUNT(DISTINCT manager_id) AS TotalManagers
FROM Employees
WHERE manager_id IS NOT NULL;

We dont have managers table the employee table and departments we need to get joining it

But here a Mnager also a employee so how can we get it 

 

Attached structure diagram

 

Kiran

SELECT COUNT(DISTINCT e.manager_id) AS manager_count
FROM Employee e
inner join manager m on m.manager_id = e.manager_id
WHERE manager_id IS NOT NULL and e.isactive =1;

Consider two table manager and employee where manageid is FK in emaployee table.

To find the count of all the managers in a database with Employee and Departments tables, you typically need to identify which employees are managers. This is usually done by checking if an employee's ID appears in a manager-related field in the Departments table or if there is a specific column in the Employee table that indicates whether an employee is a manager.

Assumptions:
Employee Table: Contains employee details, including employee_id, name, etc.

Departments Table: Contains department details, including department_id, department_name, and manager_id (which references the employee_id of the manager).

You can count the number of unique managers by querying the Departments table and counting the distinct manager_id values.

SELECT COUNT(DISTINCT manager_id) AS manager_count
FROM Departments;

Alternative Approach:
If the Employee table has a column that indicates whether an employee is a manager (e.g., is_manager), you can directly count the number of employees where is_manager is true.

SELECT COUNT(*) AS manager_count
FROM Employee
WHERE is_manager = TRUE;