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 |
+-------------------+

Last modified: February 24, 2023

Was this article helpful?