Skip to main content

Celonis Product Documentation

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: