REGR_ SLOPE
REGR_SLOPE returns the slope of a line.
Syntax
REGR_SLOPE (expression1, expression2) OVER (window_clause)
Remarks
• The return value is a numeric data type and can be NULL.
• After the elimination of NULL expression1-expression2 pairs, REGR_SLOPE makes the following computation:
COVAR_POP (expression1, expression2) / VAR_POP (expression2)
• Without a window clause, REGR_SLOPE is a simple aggregate function.