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