Returns the square root of a numeric value.

Syntax

SQRT(expression)

Arguments

expression: a numeric value of type REAL, FLOAT, or DOUBLE.

Returns

The same data type as expression.

Examples

SELECT numberCol, SQRT(numberCol) AS numberColSQRT FROM MYSQL.inventory.cust;

VALUES SQRT(9);
-- Returns 3