sql count having
snippet in sql

SQL HAVING

user5200


  SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country

  HAVING COUNT(CustomerID) > 5;
 

sql count having

user7107

SELECT COUNT( * ) 
FROM agents 
HAVING COUNT(*)>1; --count is greater than 1