SQL HAVING Clause

clause is used to filter the results of a GROUP BY query based on aggregate functions.

clause, which filters individual rows before grouping,

filters groups after the aggregation has been performed.

column1, aggregate_function(column2), column3, ...

table_name

condition

column1, column3

condition -- The condition on grouped data

column_name

Below is a selection from the "Customers" table in the Northwind sample database:

Obere Str. 57

12209