SQRT

Calculates the square root of a non-negative numeric expression.

Syntax

SQRT(expr)

Argument

expr: A positive numeric value or a value of another data type that can be implicitly converted to a numeric data type.

Example

SELECT sqrt(0), sqrt(4), sqrt(24);

+---------+----------+----------+
| SQRT(0) | SQRT(4)  | SQRT(24) |
|---------+----------+----------|
|       0 |        2 |  ~4.8989 |
+---------+----------+----------+