I'm trying to count the number of Departments in a database where there are exaclty 6 employees in each Department.
I've written the query below, but it returns the rows with the Departments where there are 6 employees.
But what I'd like is the TOTAL NUMBER of ROWS where each Department has 6 employees.
Does anyone know how I can modify this query to give me a total number, please? I'm using Sequel Server Management Studio 2012.
--Department as [Department Name]
GROUP BY Department
HAVING count(Department) = 6