CORR (value_expression_1, value_expression_2)
Syntax Elements
- value_expression_1
- A numeric expression to be correlated with a second numeric expression.
- value_expression_2
- A numeric expression to be correlated with a second numeric expression.
Computation
The equation for computing CORR is defined as follows:
| This variable … | Represents … |
|---|---|
| x | value_expression_2 |
| y | value_expression_1 |
Division by zero results in NULL rather than an error.