**HAVING** is a filter keyword that applies to the already grouped records. Unlike WHERE, which is used for conditions to filter the records, **HAVING** is used with a condition presented as an aggregate function and applied to the result obtained with the **GROUP BY**. Thus, **the HAVING operator is only used with GROUP BY and only after this operator**. 

The syntax is next: 

--do not run this query
SELECT col1, col2, ...
FROM table
WHERE conditions
GROUP BY col1, col2, ...
HAVING agg_conditions
ORDER BY col1, col2, ...;

For example, you want to get info about singers and their songs: singers' names and the price of their most expensive song. To do that, you can use GROUP BY the singer and display the price using the function **MAX()**. But let it be the limit: you need only singers such that the maximum price is less than 1000. The next query solves this problem:

SELECT singer, MAX(price)
FROM songs
GROUP BY singer
HAVING MAX(price) < 1000

This way, you can add a condition to the aggregate function **MAX()**. You cannot do that in WHERE statement, that's why we need to use HAVING.

This course was created for very beginners in programming, for those who want to start learning such a popular language for work with databases. Nowadays, all the applications and services collect some data and work with it, and basic SQL syntax is a foundation for further work with other Database Management Systems.

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

SQL Having

解答