The Group view is a graphical interface to the Group by SQL clause that allows aggregating the returned rows by a certain field (or fields). The following example illustrates the use of Group view:

The aggregation can be done through one of the four available aggregate functions: SUM, MAX, MIN and AVG.

Note that the SQL syntactical rules require that if the grouping is used at all, then ALL retrieved fields must be used in Group by section, with the exception of the aggregatable fields (those whose data type allows them to be summed up, averaged or compared on the MAX/MIN basis).