These row aggregate functions are used with COMPUTE:
| Row aggregate function | Result |
|---|---|
| SUM | Total of the values in the numeric expression |
| AVG | Average of the values in the numeric expression |
| MAX | Highest value in the expression |
| MIN | Lowest value in the expression |
| COUNT | Number of selected rows |
SUM, AVG, MAX, MIN, and COUNT ignore null values.
These row aggregate functions are the same aggregate functions that can be used with GROUP BY, except that there is no equivalent to COUNT(*). To find the summary information produced by GROUP BY and COUNT(*), use a COMPUTE clause without BY.