What is the difference between having and where clause?

Posted by

To view Verified answers click on the button below.

Ans: HAVING is used to specify a condition for a group or an aggregate function used in
select statement. The WHERE clause selects before grouping. The HAVING clause selects
rows after grouping. Unlike HAVING clause, the WHERE clause cannot contain aggregate
functions.