Aggregate

COVAR_POP

PostgreSQL

Menghitung population covariance antara dua variabel. Mengukur seberapa dua variabel berubah bersama.

Tipe hasil: double precision

Syntax

SQL

COVAR_POP(Y, X)

Ynumericwajib

Variabel pertama

Xnumericwajib

Variabel kedua

SQL

1 SELECT COVAR_POP(height, weight) AS height_weight_cov
2 FROM students;

Mengukur kovarians tinggi dan berat badan.

Hasil

height_weight_cov
125.4567890

COVAR_POP

Snowflake

COVAR_POP

BigQuery

1	SELECT COVAR_POP(height, weight) AS height_weight_cov
2	FROM students;