Online Documentation for SQL Query for DB2
Setting grouping criteria
The Grouping criteria tab allows you to set the conditions for grouping query records.
The grouping condition pattern fields are set in the same way as those of the Criteria pattern.
These conditions will be included in the HAVING statement of the generated SQL query.