What is POWER() in SQL?
The POWER() function calculates the value of the power of another
Figure 1 shows the mathematical representation of the POWER() function.
Syntax
POWER(baseNumber, exponent)
Parameters
The POWER() function requires two parameters:
- A base number.
- An exponent number.
Return value
POWER() returns the value of the base number raised to the exponent number.
Example
/*example showing how to use POWER(X)*/-- positive: baseNumber positive: exponentSELECT POWER(10, 2);-- positive: baseNumber negative: exponentSELECT POWER(0.25, -2);-- neagtive: baseNumber positive: exponentSELECT POWER(-10, 2);-- neagtive: baseNumber negative: exponentselect POWER(-0.5, -1);