Categories: Aggregate

CORR

Calculates the covariance of the values expression1 and expression2. The function name must be enclosed in double quotes ("CORR").

Syntax

CORR(expression1 NUMERIC, expression2 NUMERIC) → DOUBLE

  • expression1: BINARY, DECIMAL, DOUBLE, FLOAT, INTEGER. This parameter is the dependent value.
  • expression2: BINARY, DECIMAL, DOUBLE, FLOAT, INTEGER. This parameter is the independent value.

Examples

SELECT CORR(100, 4)
-- NaN
SELECT CORR()
-- None
SELECT CORR()
-- None