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 Remarks section below
dependent-expression The variable that is affected by the independent variable.
independent-expression The variable that influences the outcome.
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.
SQL/2003 SQL foundation feature (T621) outside core SQL.
The following example returns the number of non-NULL pairs that were used to fit the regression line.
SELECT REGR_COUNT( Salary, ( YEAR( NOW() ) - YEAR( BirthDate ) ) ) FROM Employees;
|Envoyer votre avis sur cette page par email.||Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|