REGR_COUNT Function Example | Teradata Vantage - Example: Returning the Number of Rows in regrtbl - Advanced SQL Engine - Teradata Database

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

The following SELECT statement returns the number of rows in regrtbl where neither height nor weight is null.

   SELECT REG_COUNT(weight,height) 
   FROM regrtbl;
   

Here is the result:

   Regr_Count(weight,height)
   -------------------------
                           9