Calculates one number raised to the power of another.
POWER( numeric-expression-1, numeric-expression-2 )
numeric-expression-1 The base.
numeric-expression-2 The exponent.
DOUBLE
This function converts its arguments to DOUBLE, and performs the computation in double-precision floating-point arithmetic. If any argument is NULL, the result is a NULL value.
SQL/2008 The POWER function comprises part of optional SQL/2008 language feature T621, "Enhanced numeric functions".
The following statement returns the value 64.
SELECT POWER( 2, 6 );