Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Interactive SQL Online Help Interactive SQL Version 16.0 » Query Editor Help

HAVING tab

Use this tab to restrict the rows in your result set based on group values.

Dialog components

About HAVING conditions

HAVING conditions can only be used if either the statement has a GROUP BY clause or the selected columns in the Columns tab include only aggregate functions. Any column names referenced in the HAVING clause must either be in the GROUP BY clause or be used as a parameter to an aggregate function in the HAVING clause.

Additional information

For more information, see Introducing the Query Editor.