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


Use this tab if you want to group rows in the result set.

Dialog components

About GROUP BY conditions

You can group by columns, alias names, or functions. The result of the query contains one row for each distinct set of values in the named columns, aliases, or functions. All null-containing rows are treated as a single set. The resulting rows are often referred to as groups since there is one row in the result for each group of rows from the table list. Aggregate functions can then be applied to these groups to get meaningful results.

When GROUP BY is used, the Columns tab, HAVING tab, and ORDER BY tab must not reference any identifier that is not named in the GROUP BY tab. The exception is that the Columns tab and HAVING tab may contain aggregate functions.

Additional information

For more information, see Introducing the Query Editor.