You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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 |
+---------+