SQRT

    Syntax

    SQRT( number )
    

    Description

    Returns the square root of the specified number.

    Argument types:

    • numberFractional number | Integer

    Return type: Fractional number

    Example

    [int_value] [float_value] SQRT([int_value]) SQRT([float_value])
    0 0.00 0.00 0.00
    1 1.00 1.00 1.00
    3 3.00 1.73 1.73
    4 4.00 2.00 2.00
    13 13.00 3.61 3.61
    16 16.00 4.00 4.00
    20 20.20 4.47 4.49
    25 25.00 5.00 5.00

    Data source support

    ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.