How to specify a WHERE condition in an aggregate query (Enterprise Manager)

To specify a WHERE condition in an aggregate query

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 WHERE condition.
3. Clear the check box in the Output column unless the data column is part of the GROUP BY clause or included in an aggregate function.
4. In the Criteria column, specify the WHERE condition. The Query Designer adds the condition to the HAVING clause of the SQL statement.
5. In the Group By column, select Where from the list of group and summary options. The Query Designer removes the condition from the HAVING clause in the SQL statement and adds it to the WHERE clause.