Write a query to retrieve the total number of employees in each department.

Question

Ravi Vishwakarma · Answer

To retrieve the total number of employees in each department from an SQL Server table, you can use the COUNT() function along with GROUP BY. Here's how you can write the query:

SELECT Department, COUNT(EmployeeID) AS NumEmployees
FROM YourTableName
GROUP BY Department;

Output-

Department	NumEmployees
Human Resources (HR)	25
Finance	5
Information Technology (IT)	20
Marketing	5
Research and Development (R&D)	10

In this query:

YourTableName: Replace this with the actual name of your table that contains employee data.
Department: This is the column in your table that represents each employee's department.
EmployeeID: Replace this with the actual column name that uniquely identifies each employee in your table (e.g., EmployeeID, EmployeeNumber, etc.).

The GROUP BY Department clause groups the results by the Department column, and COUNT(EmployeeID) counts the number of employees (EmployeeID) in each department. This will give you the total number of employees in each department listed in your table.

interview

Write a query to retrieve the total number of employees in each department.

Can you answer this question?

1 Answers