SQRT()

USAGE

SQRT(number)

DETAILS

• SQRT() is a mathematical function that returns the square root of a number.

The return value must fit within the DOUBLE data type or an error is generated.

A NULL is returned if the argument is a negative number or NULL.

Calling SQRT(number) is equivalent to calling POWER(number, 0.5).

EXAMPLES

SELECT SQRT(16);

+----------+
| SQRT(16) |
+----------+
|        4 |
+----------+

SELECT SQRT(10);

+-----------------+
| SQRT(10)        |
+-----------------+
| 3.1622776601684 |
+-----------------+

SELECT SQRT(-9);

+----------+
| SQRT(-9) |
+----------+
|     NULL |
+----------+

CHANGE HISTORY