Having « Query « SQL Server / T-SQL Tutorial

1.5.1.The syntax of the SELECT statement with the GROUP BY and HAVING clauses
1.5.2.HAVING clause defines the condition that is then applied to groups of rows.
1.5.3.The HAVING clause can also be used without aggregates.
1.5.4.Having and table join
1.5.5.A summary query with a search condition in the HAVING clause
1.5.6.A summary query with a compound condition in the HAVING clause
1.5.7.Selectively Query Grouped data using HAVING