List out the department id having at least four employees

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 639
SELECT DepartmentID 
FROM EmployeeTable
GROUP BY DepartmentID
HAVING COUNT(*)>=4

Comments or Responses

Login to post response