What is the HAVING clause?

What is the HAVING clause?

Rating:

The HAVING clause in a SQL SELECT statement is used with aggregate functions such as SUM, MAX, etc. It returns the results that have values matching the specified values (such as the WHERE clause). It is placed at the end of a SQL SELECT statement.

The syntax for the HAVING clause is as follows:

SELECT (column_name1)
FROM (table_name)
GROUP BY (column_name1)
HAVING (aggregate function condition)

Note: The GROUP BY clause is optional in the query.

Rating: