Syntax
SQUARE_ROOT(Argument)
Description
The SQUARE_ROOT SQL scalar function returns the square root of a number.
The argument must be a number whose value is a positive numeric value.
The data type of the result is double-precision floating point.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Example
Assume the column SQUARE is a decimal (2,1) column with a value of 9.0.
SQUARE_ROOT(SQUARE)
Returns the approximate value 3.00.
List of SQL scalar functions by topic