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.