Using a HAVING Clause

You can use a HAVING clause to specify conditions that the grouped data must meet before it is selected if you use a UniVerse stage to aggregate data.

For more information about using a UniVerse stage to aggregate data, see Aggregating Data.

To use a HAVING clause, type the clause, column, and condition in the Other clauses text entry box on the Selection tab on the Outputs page.

For example, you might choose to only output summed quantities that are greater than or equal to 1000. In this case you specify:

HAVING SUM(QtySold)>=1000

The SQL SELECT statement is updated automatically. Click the View SQL tab to display the statement.

You can also use a job parameter in the HAVING clause.