Aggregate. Returns an integer that represents the number of non-NULL number pairs used to fit the regression line.
regr_count ( dependent-expression , independent-expression )
dependent-expression | The variable that is affected by the independent variable. The expression accepts integer, long, float, timestamp, interval, and money datatypes. |
independent-expression | The variable that influences the outcome. The expression accepts integer, long, float, timestamp, interval, and money datatypes. |
This function counts all sets of non-NULL rows and returns a long. Rows are eliminated where one or both inputs are NULL.