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

SELECT SQRT(-2);
+----------+
| SQRT(-2) |
+----------+
|     NULL |
+----------+
SELECT SQRT(2);
+--------------------+
| SQRT(2)            |
+--------------------+
| 1.4142135623730951 |
+--------------------+
SELECT SQRT(4);
+---------+
| SQRT(4) |
+---------+
|       2 |
+---------+

Last modified: February 24, 2023

Was this article helpful?