摘要: SELECT ManagerID AS Manager,COUNT(*) AS Reports FROM Human.Resources.Employee2 WHERE EmployeeID !=5 GROUP BY ManagerID HAVING COUNT(*)>3;having 是聚合以后算... 阅读全文
posted @ 2015-03-03 16:54 木饭 阅读(248) 评论(0) 推荐(0)