A HAVING clause in SQL specifies that an SQL SELECT statement must only return rows where aggregate values meet the specified conditions. ... To view the present condition formed by the GROUP BY clause, the HAVING clause is used.

What are keywords in SQL?

In SQL, the keywords are the reserved words that are used to perform various operations in the database. There are many keywords in SQL and as SQL is case insensitive, it does not matter if we use for example SELECT or select.

Is HAVING a keyword in SQL?

The HAVING clause was added to SQL because the WHERE keyword cannot be used with aggregate functions.