Skip to main content
Version: 0.0.1

COVAR_SAMP

Returns the sample covariance for non-NULL pairs across all input values.

Syntax​

COVAR_SAMP(expression1 numeric, expression2 numeric) > double​

Examples

{{< codeheader "Aggregate function example" >}}

SELECT COVAR_SAMP(trip_distance_mi, fare_amount)
FROM Samples."samples.dremio.com"."NYC-taxi-trips"

-- 31.70536780565699