REGR_SXX
REGR_SXX makes the following computation after the elimination of NULL expression1-expression2 pairs:
REGR_COUNT (expression1, expression2) * VAR_POP (expression2)
Syntax
REGR_SXX (expression1, expression2) OVER (window_clause)
Remarks
• Without a window clause, REGR_SXX is a simple aggregate function. Refer
Window Clause