Skip to main content

POW

Returns the value of x raised to the power of y.

POWER() is a synonym for POW().

Syntax

POW(x, y)
POWER(x, y)

Arguments

ArgumentsDescription
xThe numerical value.
yThe numerical value.

Return Type

A Float64 data type value.

Examples

SELECT POW(-2,2);
+---------------+
| POW((- 2), 2) |
+---------------+
| 4 |
+---------------+

SELECT POW(2,-2);
+---------------+
| POW(2, (- 2)) |
+---------------+
| 0.25 |
+---------------+

SELECT POWER(-2, 2);
+--------------+
| POWER(-2, 2) |
+--------------+
| 4 |
+--------------+