Name

COMPUTE

Synopsis

COMP[UTE] [function ... OF {expression | column | alias}... 
   ON {expression | column | alias | REPORT | ROW}]

Calculates and displays summary lines using standard computations on selected subsets of rows.

function

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]
OF {expression | column | alias}

Specifies the expression (s), column (s), or alias(es) to use in the computation, which are also listed in the SQL SELECT statement.

ON {expression |column | alias | REPORT | ROW}

Specifies the entity that, when its value changes, will trigger COMPUTE to display the computed value. ON must match a corresponding BREAK statement.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset