计数和查找大于sql的值

Question

我应该显示至少有四名员工的部门的名称。我尝试了几种不同的方法，包括这个:

SELECT Department, COUNT(EmployeeID) AS NumberOfEmployee
FROM Deparment d INNER JOIN Employees e
ON d.DeparmentID = e.DeparmentID
GROUP BY Deparment
HAVING NumberOfEmployee >= 4;

当我运行查询时，它要求我输入NumberOfEmployee的参数值。谁能告诉我怎么了?

Answer 1

试试这个:

SELECT Department, COUNT(EmployeeID) AS NumberOfEmployee
FROM Deparment d INNER JOIN Employees e
ON d.DeparmentID = e.DeparmentID
GROUP BY Deparment
HAVING COUNT(EmployeeID) >= 4;

您原来的HAVING子句无效(您不能在其中使用别名)