Stay informed about any major changes. Click here to subscribe
Specifying conditions for groups
You can limit the groups that appear in a query by specifying a HAVING
clause that applies to groups as a whole. After the data has been grouped
and aggregated, the conditions in the HAVING clause are applied. Only
the groups that meet the conditions appear in the query. You can create
complex conditions for a HAVING clause by using AND and OR to link conditions.
2. In the Criteria column, specify the
condition to apply to the group. The program automatically creates a HAVING
clause in the statement in the SQL pane, such as in the following example:
