About

COMPUTE in combination with the BREAK command, calculates and prints summary lines using various standard computations.

Articles Related

Syntax

COMP[UTE] [function [LAB[EL] text] ...
   OF {expr|column|alias} ...
   ON {expr|column|alias|REPORT|ROW} ...]

Summary function

The following summary function are available:

• SUM : Sum of the values in the column.
• MINIMUM: Minimum value in the column.
• MAXIMUM: Maximum value in the column.
• AVG: Average of the values in the column.
• STD: Standard deviation of the values in the column.
• VARIANCE: Variance of the values in the column.
• count: Number of non-null values in the column.
• NUMBER: Number of rows in the column.