SQRT

Description

Returns the square root of a value, where the input value must be greater than or equal to 0.

Aliases

• DSQRT

Syntax

SQRT(<a>)

Parameters

Parameter	Description
<a>	The value whose square root is to be calculated

Return Value

The square root of parameter a.

Examples

select sqrt(9),sqrt(2)

+-------------------------+-------------------------+
| sqrt(cast(9 as DOUBLE)) | sqrt(cast(2 as DOUBLE)) |
+-------------------------+-------------------------+
|                     3.0 |      1.4142135623730951 |
+-------------------------+-------------------------+