Use this page to specify the information for a GROUP BY clause
in the SELECT statement.
The GROUP BY clause specifies that rows that are retrieved by
the WHERE clause should be grouped and condensed in such a way that all rows
having the same values for the grouping columns are treated as a single row
in the result set.
- unlabeled field
- Shows the list of grouping expressions that are
currently defined. Initially, this list contains only the default Grouping
root.
- Type
- Shows the grouping type for the selected grouping
expression.
- Column
- Shows the columns, expressions, and grouping types
that are defined for the selected grouping expression. To add a new element,
double-click the first empty row, and then select a column or grouping type,
or click Build Expression and create an expression.