how to place Conditions on Groups with the HAVING Clause

byAdmin •March 08, 2012

in this Database sql server tutorial we will learn that how to Place Conditions on Groups with the HAVING Clause.

see the below sql query.

SELECT ReportsTo AS Manager, COUNT(*) AS Reports
FROM Employees
GROUP BY ReportsTo
HAVING COUNT(*) > 4