Example
Return 4 raised to the second power:
SELECT POWER(4, 2);
Definition and Usage
The POWER() function returns the value of a number raised to the power of another number.
Tag: mysql power bi gateway
MySQL POW Function
Example
Return 4 raised to the second power:
SELECT POW(4, 2);
Definition and Usage
The POW() function returns the value of a number raised to the power of another number.
Syntax
POW(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:
SELECT POW(8, 3);