How to Use HAVING in SQL

The HAVING clause is used to filter groups created by the GROUP BY clause based on a condition. It works like WHERE, but for aggregated data.

Syntax:

SELECT column1, aggregate_function(column2)FROM table_nameGROUP BY column1HAVING aggregate_function(column2) condition;

Example:

Suppose you have a table sales with columns: region, sales_amount.

To find regions where the total sales exceed 100,000:

SELECT region, SUM(sales_amount) AS total_salesFROM salesGROUP BY regionHAVING SUM(sales_amount) > 100000;

How it works:

• First, rows are grouped by region.

• Then, groups with SUM(sales_amount) greater than 100,000 are included in the result.

• Groups that do not satisfy the HAVING condition are excluded.

Difference Between WHERE and HAVING:

If you want, I can show you examples combining WHERE, GROUP BY, and HAVING!