What is the difference between having and where clause?

409 viewsSQLSQL
0

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
Write your answer.

Posted

in

Tags:

Comments

Leave a Reply

A Tribute to Dilip Kumar