Online Documentation for SQL Query for Oracle
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.