Aggregate Transformation GROUP BY or HAVING Clause

You can specify a GROUP BY or HAVING clause for aggregation.

GROUP BY Clause

Use a GROUP BY clause to group rows based on the value of one or more expressions. A GROUP BY clause groups rows but does not guarantee the order of the result set.

Specify a GROUP BY clause in one of the following ways:

HAVING Clause

Use a HAVING clause to restrict the groups of rows to those groups for which a specified condition is TRUE.

Specify a HAVING clause in one of the following ways:

Click Next to continue.