Having clause is used to filter data according to the conditions provided. Having a clause is generally used in reports of large data. Having clause is only used with the SELECT clause. The expression in the syntax can only have constants

The HAVING clause is then applied to the rows in the result set. Only the groups that meet the HAVING conditions appear in the query output. You can apply a HAVING clause only to columns that also appear in the GROUP BY clause or in an aggregate function.

The having clause is used to filter data based on the conditions specified. A clause is commonly used in huge data reports. The having clause is only used in conjunction with the SELECT clause. The syntactic expression can only contain constants.