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 ViewDistinct.

To create a condition that each output group must satisfy, select ViewHaving Condition for Group to display the 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.

Type 15 in the Numeric field and select OK.

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

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

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

Select OK.

Select ToolsRun QueryRun Immediate to display the divisions whose minimum employee education level is greater than 15.

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