Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
POW
Returns the given number exponentiated to the given power.
Syntax
POW ( number, power )
POWER ( number, power )
Arguments
- expression: any valid numeric expression.
- power: any valid numeric expression.
Return Type
Float or double. If either argument is null, returns NULL.
Examples
SELECT POW(2, 8);
+-----------+
| POW(2, 8) |
+-----------+
| 256 |
+-----------+
SELECT POW(2, 16);
+------------+
| POW(2, 16) |
+------------+
| 65536 |
+------------+
SELECT POW(2, 24);
+------------+
| POW(2, 24) |
+------------+
| 16777216 |
+------------+
SELECT POW(2, 2.5);
+-------------------+
| POW(2, 2.5) |
+-------------------+
| 5.656854249492381 |
+-------------------+
