SQL SERVER 2012 第三章 T-SQL 基本语句 having子句

SELECT ManagerID AS Manager,COUNT(*) AS Reports FROM Human.Resources.Employee2 WHERE EmployeeID !=5 GROUP BY ManagerID SELECT ManagerID AS Manager,COUNT(*) AS Reports