Difference between Having and Where in SQL, sqlhavingwhere

Difference between Having and Where in SQL, sqlhavingwhere

Description

Where

Select before grouping

Having

Having can select an aggregation function only after grouping.
Eg:

// Select count (*) from awhere a. a1> 0 group by a2;

// However, select count (*) from awhere a. a1> 0 and count (*)> 1 group by a2;

// You must change the value to havingSELECT COUNT (*) from awhere a. a1> 0 group by a2HAVING COUNT (*)> 1.

Articles you may be interested in:

• Difference between having and where in SQL
• Difference between where and having in SQL statements