Skip to main content

SQRT

Description

The SQRT function calculates the positive square root of the specified value.

It can be applied to INT or FLOAT columns. The resulting column is of type FLOAT.

Syntax

  SQRT ( table.column )
 

NULL handling

If the input value is NULL, the result is NULL as well.

Example

[1]

Calculate the square root of three Integers

Query

Column1

         SQRT ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : int

1

4

9

null

Result

Column1 : float

1.0

2.0

3.0

null

See also: