Computes the square root of the input parameter. Input value can be a Decimal or Integer literal or a reference to a column containing numeric values. All generated values are non-negative. |
Numeric literal example:
sqrt(25) |
Output: Returns the square root of 25, which is 5.
Column reference example:
sqrt(MyValue) |
Output: Returns the square root of the values of the MyValue column.
sqrt(numeric_value) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| numeric_value | Y | string, decimal, or integer | Name of column or Decimal or Integer literal to apply to the function |
Name of the column or numeric literal whose values are used to compute the square root.
NOTE: Negative input values generate null output values. |
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String (column reference) or Integer or Decimal literal | 25 |