POW

All functions > MATH > POW

Returns the value of a number raised to the power of another number.

Syntax

POW(base: T, exponent: T) → T
sql

Type Parameters:

  • T: BIGINT or DOUBLE

Arguments

ParameterTypeRequiredDescription
baseTYesThe base number
exponentTYesThe power to raise the base to

Returns

Same as input type - BIGINT or DOUBLE

Notes

  • POW(x, 0) = 1 for any non-zero x
  • POW(0, y) = 0 for positive y
  • POW(1, y) = 1 for any y
  • Returns NULL if either input is NULL
  • Can result in very large or very small numbers
  • For negative bases with fractional exponents, result may be complex
  • Operator form: base ^ exponent
  • Alias: POWER(base, exponent)

Aliases

  • POWER

See also

Examples

Suggest changes to this page
Last update at: 2025/10/13 10:23:46