Open topic with navigation

Learn more about Toad for SQL Server at Dell Software Find solutions and downloads at the Toad for SQL Server Support Portal

Set Having Conditions

You can set a Having condition that defines conditions for displaying groups in a query.

Notes:

• You must add a Group By clause for this option to be available.

• If you reverse engineer a query that contains a Having condition from the Editor or edit it in the Query tab of the Query Builder, it displays in a Global Having Clause on the Diagram pane rather than the Having Condition field below the Diagram pane. You can double-click the Global Having clause, or can click to edit it
• This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set a Having condition

1. Select a column from a table in the Diagram tab.

2. Select the Having Condition field below the column and click .

3. Complete the fields as necessary. Review the following for additional information:

   Form Tab	Description
   Field	Select an operator or predicate to use in this condition.
   Aggregate	Select one of the following functions to calculate column values: Avg—Returns the average of the values in a group. Avg (Distinct)—Returns the average of the unique values in a group. Count—Returns the total number of items in a column. This function does not ignore NULL values when calculating results. Count (Distinct)—Returns the total number of unique values in a column. Max—Returns the maximum value for the column. Min—Returns the minimum value for the column. Stddev—Returns the sample standard deviation of a numeric expression evaluated over a set. Sum—Returns the sum of all the values in the expression. Sum (Distinct)—Returns the sum of all the unique values in the expression. Note: If you add a Group By clause, you must specify an aggregate function for any remaining columns.
   Value 1 Type Value 2 Type	Select whether the expression is a column or constant. After selecting this option, select the column name or enter a constant in the field. Note: The Value 2 Type field is only available if you selected the Between predicate.
   Formula Tab	Description
   Functions	Perform an incremental search or select a function, and then select a column on which to perform the function.
   Operators	Select an operator or predicate to use in this condition.
   Columns and Calculated Fields	Select a column to apply a function or operator against.

Tip: To remove a Having condition, open the Having condition window and click Remove.

Related Topics

Build Queries Visually 

Add Subqueries 

of