![REGR_AVGY function [Aggregate]](arrow-left.gif){kind=icon}
![REGR_INTERCEPT function [Aggregate]](arrow-right.gif){kind=icon}
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)
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 an UNSIGNED BIGINT as the result.
ROLLUP and CUBE are not supported in the GROUP
BY clause with Syntax 1. DISTINCT is not supported.
Syntax 2 represents usage as a window function in a SELECT statement. As such, you can specify elements of window-spec either in the function syntax (inline), or with a WINDOW clause in the SELECT statement. For information on how to specify the window, see “Analytical functions”.
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;
