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.