What is the difference between having and where clause?

422 viewsJanuary 11, 2023SQLSQL

Gautam Sarswat 101 January 10, 2023 0 Comments

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.

Gautam Sarswat Changed status to publish January 11, 2023