ID EN
Mathematical Functions

SQRT(X)

MySQL 8.4

Returns the square root of a nonnegative number X. If X is NULL, the function returns NULL.

Syntax

MYSQL
SELECT SQRT(4);
2
SELECT SQRT(20);
4.4721359549996
SELECT SQRT(-16);
NULL

Examples

Example
MYSQL
SELECT SQRT(4);
2
SELECT SQRT(20);
4.4721359549996
SELECT SQRT(-16);
NULL