Previous Next JavaScript must be enabled to correctly display this content

## power function

The `pow` function returns the value of the first expression raised to the power of the second expression.

Syntax:

    double pow(n2,n1)

Semantics:

- n1, n2: The arguments n1 and n2 are expressions that resolve to numbers.
- return type: double.
  - Returns a NULL value in the following cases:
    - If either of the arguments resolves to a NULL value
    - If either of the arguments does not resolve to a number
  - Returns positive infinity if n2 resolves to positive/negative infinity.
  - Returns positive infinity if n1 resolves to positive infinity and zero if n1 resolves to negative infinity.

Example 12-87 power function

    SELECT pow(n2,n1) FROM PHtable

Value of n | Value of b | Output
--- | --- | ---
2 | 4 | 16.0
2 | 0 | 1.0
-0.5 | 4 | 0.0625
0.5 | -4 | 16.0