SQRT

Returns the square root of a number.

Signatures

Returns: Square root result

SQRT(number: T) → DOUBLE

sql

Parameter	Type	Required	Description
`number`	`T`	Yes	Non-negative number to find the square root of

Notes

Only defined for non-negative numbers (number >= 0)
SQRT(0) = 0
SQRT(1) = 1
SQRT(x²) = x for non-negative x
Returns NULL if input is NULL
Returns NaN for negative numbers
Equivalent to POW(number, 0.5)

Examples

FeatureQL

SELECT
    f1 := SQRT(0.0e0),  -- Square root of 0
    f2 := SQRT(1.0e0),  -- Square root of 1
    f3 := SQRT(4.0e0),  -- Square root of 4
    f4 := SQRT(9.0e0),  -- Square root of 9
    f5 := SQRT(16.0e0),  -- Square root of 16
    f6 := SQRT(25.0e0),  -- Square root of 25
    f7 := SQRT(2.0e0)  -- Square root of 2
;

Result

f1 VARCHAR	f2 VARCHAR	f3 VARCHAR	f4 VARCHAR	f5 VARCHAR	f6 VARCHAR	f7 VARCHAR
0.0	1.0	2.0	3.0	4.0	5.0	1.4142135623730951

Suggest changes to this page

Last update at: 2026/03/03 16:47:38

On this page

Signatures Notes Examples