POWER
Description
The POWER function returns the value of the specified expression to the specified power.
It can be applied to INT or FLOAT columns. The resulting column is of type FLOAT.
Syntax
POWER ( table.column, exponent )
NULL handling
If one of the input values is NULL, the result is NULL as well.
Examples
[1] Calculate the power using column values as exponent | ||||||||||||||||||||||
| ||||||||||||||||||||||
|
[2] Calculate the power using a constant value as exponent | ||||||||||||
| ||||||||||||
|