Examples

Subsetting Groups of Data with the HAVING Condition

The HAVING condition specifies the condition or conditions that each group must satisfy in order to be included in the query output. You can use a HAVING condition to subset grouped data by using HAVING in the same query with a GROUPBY and a summary function.

Which divisions in the previous example have a minimum employee education level that is greater than 15 years? To find out, select SAMPLE.EMPINFO and add it to the Selected Tables list. Select OK.

In the SQL QUERY COLUMNS window, select DIVISION and add it to the Selected Columns list. Remove duplicate values by selecting View Distinct.

HAVING EXPRESSION Window

To create a condition that each output group must satisfy, select View Having Condition for Group to display the HAVING EXPRESSION window.

[HAVING EXPRESSION window]

Select Summary Functions. Select MIN from the list of summary functions.

Select Education level from the Available Columns list.

Select GT from the list of operators that appears.

Select <CONSTANT enter value> from the Available Columns list. The Numeric Values dialog box appears.

[Numeric Values dialog box]

Type 15 in the Numeric field and select OK.

In the HAVING EXPRESSION window, select OK to return to the SQL QUERY COLUMNS window.

Viewing the Results of the HAVING Condition

Select View Group(s) for Summary Functions to display the GROUP BY COLUMNS window.

[GROUP BY COLUMNS window]

Select DIVISION from the Available Columns list and add it to the Group By Columns list.

Select OK.

Select Tools Run Query Run Immediate to display the divisions whose minimum employee education level is greater than 15.

[Query output]

In the SQL QUERY COLUMNS window, select Tools Reset to reset the query and return to the SQL QUERY TABLES window. Select OK from the dialog box that appears.

Top of Page