1. SQL Reference Guide
  2. Built-in Functions
  3. Functions of Mathematical Operations
  4. power function

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:
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