SQRT

Returns the square root of a numeric expression.

Syntax

SQRT(<value>);

Parameter	Description	Supported input types
`<value>`	Value that the `SQRT` function is applied to	`DOUBLE PRECISION`

When input value is integer data type, it is implicitly converted to DOUBLE PRECISION.
When input value is NUMERIC, the SQRT function returns an error.
When input value is negative, the SQRT function returns an error.

DOUBLE PRECISION.

The following example returns the square root of 64:

SELECT SQRT(64);

sqrt double
8

Rows: 1Execution time: 5.22ms

⌘I