SQL HAVING Clause.

If you want to display the department that has numbers of employee more than 2.
Query will be :

SELECT Dept,COUNT(Dept) as Total
FROM Employee_Table
GROUP BY Dept 
HAVING COUNT(Dept) > 2

Result :

Dept          Total
IT              10
HR              3