DataFlux Data Management Studio 2.6: User Guide

Having Tab

You can use the Having tab to specify an expression for a HAVING clause. A HAVING clause works with the GROUP BY clause to restrict the groups that are displayed in the output, based on one or more specified conditions.

The Filters section of the Having tab contains a toolbar that performs the following functions:

The Filter Table contains the following elements:

Boolean - Specifies Boolean values for the filter. Click the drop-down menu to display the available values. The only value displayed for the first filter is NOT. All subsequent filters display AND, OR, AND NOT, and OR.

Open Parenthesis - Adds an opening parenthesis to the filter.

Operand - Enters operands on both sides of the filter operator. Click the drop-down menu to display the available values Select Field displays the Select Field dialog, which enables you to select fields from the source and target tables for the query. CASE displays the Case tab , which you can use to create a case expression for the clause. Subquery adds a select * from statement to the operand, where you can develop a subquery that you can nest in the clause. Expression displays the Expression tab, which enables you to create complex filters. When appropriate, you can click Insert Values in the right-hand operand to see a list of available values. Note that you can use the Enclose values in parentheses option in the Select Values dialog to specify that the inserted values are enclosed in parentheses.

Operator - Adds an operator to the filter. Click the drop-down menu to select from the following values: =, <>, IN (,), NOT IN (,), >, >=, <, <=, BETWEEN, NOT BETWEEN, EXISTS, NOT EXISTS, IS NULL, NOT IS NULL, CONTAINS, NOT CONTAINS, LIKE (Matches pattern), and NOT LIKE (Does not match pattern).

Close Parenthesis - Adds a closing parenthesis to the filter.

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_SQL_Having.html