On this page

    Categories: Math


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


    POWER(numeric_expression double, power double) → double

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


    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.