SQRT function

The SQRT function returns the square root of a floating-point number; only the built-in types REAL, FLOAT, and DOUBLE PRECISION are supported.

The return type for SQRT is the type of the parameter.

Note: To execute SQRT on other data types, you must cast them to floating-point types.

Syntax

SQRT ( number )

Examples

-- throws an exception if any row stores a negative number:
VALUES SQRT(3421E+09)

-- returns the square root of an INTEGER after casting it as a
-- floating-point data type:
SELECT SQRT(myDoubleColumn) FROM MyTable

VALUES SQRT (CAST(25 AS FLOAT));