Link Search Menu Expand Document

POW, POWER

Returns a number <val> raised to the specified power <exp>.

Syntax

POW(<val>, <exp>);
POWER(<val>, <exp>);
Parameter Description
<val> Valid values include column names, functions that return a column with numeric values, and constant numeric values.
<exp> The exponent value used to raise <val>

Example

SELECT
    POW(2, 5);

Returns: 32