REGR_COUNT Function Example | VantageCloud Lake - Example: Returning the Number of Rows in regrtbl - Teradata Vantage

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