Link Search Menu Expand Document

This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

SQRT

Returns the square root of a non-negative numeric expression.

Syntax 

SQRT(<value>);

Parameters

Parameter Description Supported input types
<value> Value that the SQRT function is applied to DOUBLE PRECISION

Return Types

  • DOUBLE PRECISION if value is positive
  • NULL if value is negative

Example

The following example returns the square root of 64:

SELECT
    SQRT(64);

Returns: 8