Categories: Numeric

SQRT

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

Syntax

SQRT(numeric_expression double) → double

  • numeric_expression: Numeric expression to calculate the square root for.

Examples

SELECT SQRT(25.25)
-- 5.024937810560445
SELECT SQRT(-25.25)
-- NaN

SQRT(numeric_expression int64) → int64

  • numeric_expression: Numeric expression to calculate the square root for.

Examples

SELECT SQRT(25)
-- 5

SQRT(numeric_expression int32) → int32

  • numeric_expression: Numeric expression to calculate the square root for.

Examples

SELECT SQRT(25)
-- 5

SQRT(numeric_expression float) → float

  • numeric_expression: Numeric expression to calculate the square root for.

Examples

SELECT SQRT(25.25)
-- 5.024937810560445

Usage Notes

If the input is a non-negative value, NaN will be returned.