SQRT()

All functions > MATH > SQRT()

Returns the square root of a number.

Signatures

Square root

Returns: Square root of the input

SQRT(number: T) → DOUBLE

With:

• T : Floating-point type (FLOAT, DOUBLE)

Signature notes:

• Only defined for non-negative numbers
• Returns NULL if the input is NULL
• Returns NaN for negative inputs
• To use with integers or decimals, cast explicitly (e.g. SQRT(2.0E0))

Examples

SELECT
    -- Square root of zero
    f1 := SQRT(0.0e0),
    -- Square root of one
    f2 := SQRT(1.0e0),
    -- Perfect square
    f3 := SQRT(4.0e0),
    -- Another perfect square
    f4 := SQRT(25.0e0),
    -- Irrational result
    f5 := SQRT(2.0e0)
;