我想知道例如，如果我有以下情况：
Employees: nameOfEmployee,numberOfEmployee,numberOfDepartment,....,....,....,....,...,....,....
Departments: numberOfDepartment,numberOfEmployees,....,....,....,....,...,....,....
并且表中已经有行，请在名称为Departments.numberOfEmployees的值中添加nameOfEmployee
到目前为止，我想到的唯一一件事是：
UPDATE Departments
SET numberOfEmployees=COUNT(Employees.nameOfEmployee)
FROM Employees
WHERE Departments.numberOfDepartment=Employees.numberOfDepartment
我知道这可能甚至没有任何意义。我刚刚开始使用SQL
只需尝试一下（未测试）
UPDATE Departments
SET numberOfEmployees=(SELECT COUNT(Employees.nameOfEmployee)
FROM Employees
WHERE Departments.numberOfDepartment=Employees.numberOfDepartment)
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句