Skip to main content

POW

Calculates x raised to the power y.

See also:
[SELECT]

Syntax​

SELECT POW(x, y) FROM <multipartIdentifier>;
-- or using the equivalent
SELECT POWER(x, y) FROM <multipartIdentifier>;

Arguments​

x
The base number, which is a numeric expression.

y
The exponent to which the base number x is raised, also a numeric expression.

Return Value(s)​

Returns the result of x raised to the power y.

Examples​

Calculate x raised to the power y​

SELECT POW(2, 3) AS result;