Returns an integer that represents the number of non-NULL number pairs used to fit the regression line.

**REGR_COUNT(** *dependent-expression *,* independent-expression*** )**

**REGR_COUNT(** *dependent-expression *,* independent-expression*** ) OVER (**

*window-spec* : see Syntax 2 instructions in the Usage section below

**dependent-expression** The variable that is affected by the independent variable.

**independent-expression** The variable that influences the outcome.

This function returns a LONG as the result.

Syntax 2 represents usage as a window function in a SELECT statement. As such, elements of *window-spec* can be specified either in the function syntax (inline), or in conjunction with a WINDOW clause in the SELECT statement. See the *window-spec* definition provided in WINDOW clause.

For more information about using window functions in SELECT statements, including working examples, see Window functions.

For more information about the statistical computation performed, see Mathematical formulas for the aggregate functions.

- REGR_INTERCEPT function [Aggregate]
- REGR_COUNT function [Aggregate]
- REGR_SLOPE function [Aggregate]
- REGR_SXX function [Aggregate]
- REGR_SXY function [Aggregate]
- REGR_SYY function [Aggregate]
- REGR_AVGY function [Aggregate]
- REGR_AVGX function [Aggregate]
- COUNT function [Aggregate]
- AVG function [Aggregate]
- SUM function [Aggregate]

**SQL/2003**SQL foundation feature (T621) outside of core SQL.

The following example returns a value that indicates the number of non-NULL pairs that were used to fit the regression line. This function returns the value 75.

SELECT REGR_COUNT( Salary, ( YEAR( NOW() ) - YEAR( BirthDate ) ) ) FROM Employees;