SQL POWER Function

POWER returns a value raised to a specified power.

The first parameter is the base and the second indicates the power.



The example raises 2 to the power of 3.

SELECT POWER(2, 3) AS '2^3'
Result:  1 record


Syntax of the POWER function.

POWER(base, power)

base -- a number indicating the base value.

power -- a number indicating the number of times the base is multiplied by itself.

You may also like

Last updated on Dec 21, 2023