SQRT
On this page
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.NULL.
Examples
SELECT SQRT(-2);
+----------+
| SQRT(-2) |
+----------+
| NULL |
+----------+SELECT SQRT(2);
+--------------------+
| SQRT(2) |
+--------------------+
| 1.4142135623730951 |
+--------------------+SELECT SQRT(4);
+---------+
| SQRT(4) |
+---------+
| 2 |
+---------+Last modified: February 24, 2023