COMPUTE Syntax

The COMPUTE clause has the following syntax:

COMPUTE row_aggregate(column_name)
[, row_aggregate(column_name)...]
[BY column_name [, column_name]...]

For the complete syntax of the SELECT statement, see Creating Basic Queries.

Note You cannot include text or image datatypes in a COMPUTE or COMPUTE BY clause.