Product

Returns the product of all values in a column.

Syntax:

►►─┬─ PROD ────┬─ (value) ────────────────────────────────────────────────────►◄
   └─ PRODUCT ─┘

Invocation names:

PROD
PRODUCT

Parameters:

column-name: Specifies the list of values on which the product is calculated.

Example:

In this example, the compounded interest rate for 2 mutual funds is calculated:

select product(interest-rate) from mutual-funds