Sql count having

This article is tagged with: Sql count having and mysql

sql count having

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

SQL HAVING

SELECT COUNT(CustomerID), Country
FROM Customers
GROUP BY Country
HAVING COUNT(CustomerID) > 5;

This article is tagged with: Sql count having and mysql