On this page

    Categories: Math

    POWER

    Returns the result of raising the input value to the specified power.

    Syntax

    POWER(numeric_expression double, power double) → double

    • numeric_expression: The input expression.
    • power: The power to raise the numeric_expression to.

    Examples

    SELECT POWER(5, 2)
    -- 25.0
    
    SELECT POWER(0.1, 2)
    -- 0.010000000000000002
    
    SELECT POWER(-2, 2)
    -- 4.0
    
    SELECT POWER(10, -2)
    -- 0.01
    

    Usage Notes

    This function always returns a double even if the parameters are both integers.