Reference Guide > TDV Support for SQL Functions > Aggregate Functions > REGR_SXY
 
REGR_SXY
REGR_SXY makes the following computation after the elimination of NULL expression1-expression2 pairs:
REGR_COUNT (expression1, expression2) * COVAR_POP (expression1, expression2)
Syntax
REGR_SXY (expression, expression) OVER (window_clause)
Remarks
Without a window clause, REGR_SXY is a simple aggregate function. Refer Window Clause