16.20 - Example: Using the SELECT statement to Return the Sample Covariance of Weight and Height - Advanced SQL Engine - Teradata Database

This example is based on the following regrtbl data. Nulls are indicated by the QUESTION MARK character.

The following SELECT statement returns the sample covariance of weight and height where neither weight nor height is null.

   SELECT COVAR_SAMP(weight,height) 
   FROM regrtbl;

   Covar_Samp(weight,height)
   -------------------------
                         150