What is difference between having and where clause?

Difference between WHERE and HAVING clause The WHERE clause is used in the selection of rows according to given conditions whereas the HAVING clause is used in column operations and is applied to aggregated rows or groups. If GROUP BY is used then it is executed after the WHERE clause is executed in the query.

Related Posts: