DQL Statements › SET Statements › Mathematical Functions in SET › Standard Functions

Standard Functions

CA Dataquery provides the following standard functions for use in a SET statement of a query.

►►─┬─ MAX(arg1,arg2,...,argn) ─┬──────────────────────────────────────────────►◄
   ├─ MIN(arg1,arg2,...,argn) ─┤
   ├─ AVG(arg1,arg2,...,argn) ─┤
   └─ ABS(arg1) ───────────────┘

Description

MAX(arg1,arg2,...,argn)

Returns the highest value of a list of arguments.

MIN(arg1,arg2,...,argn)

Returns the lowest value of a list of arguments.

AVG(arg1,arg2,...,argn)

Returns the average value of a list of arguments.

ABS(arg1)

Returns the absolute value of the argument.

The argument list in parentheses must immediately follow the function name with no intervening blanks. An argument can be a literal value, numeric database column or the result from a previous SET statement.