Outdated Version
You are viewing an older version of this section. View current production version.
SQRT
Returns the square root of a given number, accurate to within the representation of doubles.
Syntax
SQRT ( number )
Arguments
- expression: any valid numeric expression.
Return Type
Float or double. If number is is zero, returns 0. If less than 0, returns NULL
.
Examples
memsql> select sqrt(-2);
+----------+
| sqrt(-2) |
+----------+
| NULL |
+----------+
memsql> select sqrt(2);
+--------------------+
| sqrt(2) |
+--------------------+
| 1.4142135623730951 |
+--------------------+
memsql> select sqrt(4);
+---------+
| sqrt(4) |
+---------+
| 2 |
+---------+