Subsetting Groups of Data with the HAVING Condition

The HAVING condition specifies the condition(s) 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.

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.

Viewing the Results of the HAVING Condition

Select
View – Group(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
Tools – Run Query – Run Immediate
to display the divisions whose minimum employee education level is greater than 15.

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.