How to specify a condition for a group (Enterprise Manager)

To specify a condition for a group

1. Specify the groups for your query. For details, see Grouping Rows in Query Results.
2. If it is not already in the Grid pane, add the column on which you want to base the condition. (Most often the condition involves a column that is already a group or summary column.) You cannot use a column that is not part of an aggregate function or of the GROUP BY clause.
3. In the Criteria column, specify the condition to apply to the group.

   The Query Designer automatically creates a HAVING clause in the statement in the SQL pane.

   Repeat steps 2 and 3 for each additional condition you want to specify.