POWER
returns a value raised to a specified power.
The first parameter is the base and the second indicates the power.
The example raises 2 to the power of 3.
SELECT POWER(2, 3) AS '2^3'
2^3 |
---|
8 |
Syntax of the POWER function.
POWER(base, power)
base
-- a number indicating the base value.
power
-- a number indicating the number of times the base
is multiplied by itself.