COMPUTE
COMP[UTE] [function
... OF {expression
|column
|alias
}... ON {expr
ession |column
|alias
| REPORT | ROW}]
Calculates and displays summary lines using standard computations on selected subsets of rows.
One or more of the following standard mathematical functions (separated by spaces if more than one is specified):
AVG |
COU[NT] |
MAX[IMUM] |
MIN[IMUM] |
NUM[BER] |
STD |
SUM |
VAR[IANCE] |
Specifies the expression (s), column (s), or alias(es) to use in the computation, which are also listed in the SQL SELECT statement.
Specifies the entity that, when its value changes, will trigger COMPUTE to display the computed value. ON must match a corresponding BREAK statement.