Groups page

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.
Related tasks
Creating GROUP BY clauses in the SQL builder
Creating expressions in the Expression Builder wizard

Feedback