Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL HAVING Keyword

Concept visual

SQL HAVING Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

HAVING Keyword

Having

The HAVING

command is used instead of WHERE with aggregate functions. The following SQL lists the number of customers in each country. Only include countries with more than 5 customers:

Example

SELECT COUNT(CustomerID), Country

FROM Customers

GROUP BY Country

HAVING COUNT(CustomerID) > 5;
The following SQL lists the number of customers in each country, sorted high to low (Only include countries with more than 5 customers):

Example

SELECT COUNT(CustomerID), Country

FROM Customers

GROUP BY Country

HAVING COUNT(CustomerID)

> 5

ORDER BY COUNT(CustomerID) DESC;

SQL HAVING Keyword

Concept visual

SQL HAVING Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

HAVING Keyword

Having

The HAVING

command is used instead of WHERE with aggregate functions. The following SQL lists the number of customers in each country. Only include countries with more than 5 customers:

Example

SELECT COUNT(CustomerID), Country

FROM Customers

GROUP BY Country

HAVING COUNT(CustomerID) > 5;
The following SQL lists the number of customers in each country, sorted high to low (Only include countries with more than 5 customers):

Example

SELECT COUNT(CustomerID), Country

FROM Customers

GROUP BY Country

HAVING COUNT(CustomerID)

> 5

ORDER BY COUNT(CustomerID) DESC;

SQL HAVING Keyword

SQL HAVING Keyword

HAVING Keyword

Previous

Next

Having

The HAVING

Example

FROM Customers

GROUP BY Country

Example

FROM Customers

GROUP BY Country

HAVING COUNT(CustomerID)

Previous

Next

SQL HAVING Keyword

SQL HAVING Keyword

HAVING Keyword

Previous

Next

Having

The HAVING

Example

FROM Customers

GROUP BY Country

Example

FROM Customers

GROUP BY Country

HAVING COUNT(CustomerID)

Previous

Next