Example
Return 4 raised to the second power:
sql
SELECT POWER(4, 2);
Definition and Usage
The POWER() function returns the value of a number raised to the power of another number.
Note: This function is equal to the POW() function.
Syntax
text
POWER(x, y)
Parameter Values
| Parameter | Description |
|---|---|
| x | Required. A number (the base) |
| y | Required. A number (the exponent) |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return 8 raised to the third power:
sql
SELECT POWER(8, 3);