我如何计算员工总数 [英] How Can I Count Total Number Of Employees

问题描述

我在这里使用三张桌子......





员工，员工姓名，部门



ID Ecode Dept ID Ename ID deptName

1 10 1 1 raja 1 Admin

2 20 2 2 siva 2 prodn

3 30 3 3 kamal 3账户

4 40 5 4 ramu



如何计算每个员工的总人数部门和部门名称



我的查询....

Here i am using three tables like...


Employee , Employee Name , Department

ID Ecode Dept ID Ename ID deptName
1 10 1 1 raja 1 Admin
2 20 2 2 siva 2 prodn
3 30 3 3 kamal 3 Accounts
4 40 5 4 ramu

how can i count total number of employees in each department and department name

My Query....

select
Employee.ID,Employee.Dept,
Department.ID,Department.DepartmentName,
EmployeeName.ID,EmployeeName.Ename

from
(Employee inner join Department on Employee.Dept=Department.ID)
inner join EmployeeName on Employee.ID=EmployeeName.ID select COUNT(id) from Employee;

但它计算了emp.ID的总数....

But it counted total number of emp.ID....

推荐答案

您的问题是：

我如何计算每个部门和部门名称的员工总数




您可以在查询中使用group by子句。



例如以下查询将为您提供总计员工人数和离职名称



在Employee.Dept = Department的Employee内部联接部门选择COUNT（Employee.id）为TotalEmployees，Department.ID，Department.DepartmentName .ID GROUP BY Department.ID，Department.DepartmentName

Your question is :
how can i count total number of employees in each department and department name


You can use the group by clause in your query.

for example the following query will give you the total number of employees and depart name

Select COUNT(Employee.id) as TotalEmployees ,Department.ID,Department.DepartmentName from Employee inner join Department on Employee.Dept=Department.ID GROUP BY Department.ID,Department.DepartmentName

您好，



总计员工人数



从员工中选择[员工总数]的计数（ID）



对于每个部门的员工总数



选择计数（e.ID）为[每个部门的员工总数]，d.ID，d.deptName来自员工e

内部加入部门d d.ID = e.Dept

Group by d.ID，d.deptName

Hi,

For Total No Of Employees

Select Count(ID) as [Total No Of Employees] from Employee

For Total No Of Employees for Each Department

Select Count(e.ID) as [Total No Of Employees for Each Department], d.ID, d.deptName from Employee e
Inner Join Department d on d.ID = e.Dept
Group By d.ID, d.deptName

这篇关于我如何计算员工总数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！