HAVING Clause Example

This example selects the job titles assigned to more than one employee in the Washington region.

SELECT Title, Count(Title) as Total FROM Employees WHERE Region = 'WA' 
GROUP BY Title 
HAVING Count(Title) > 1;