SQL POWER Function

POWER returns a value raised to a specified power.

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

Example

#

The example raises 2 to the power of 3.

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

Syntax

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



Guides


vsn 3.1