SQRT
The SQRT function returns the square root of the input argument.
Syntax
SQRT (argument)
Remarks
The table lists the valid input argument data types and the resulting output data types.
Data Type of Argument | Output Type | Notes |
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT | FLOAT | Input value must not be negative.
Output value is greater than or equal to 0. |
NULL | NULL | |
Example
SELECT SQRT(6);
The result is 2.449489742783178.