REGR_INTERCEPT
REGR_INTERCEPT returns the y-intercept of the regression line.
Syntax
REGR_INTERCEPT (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_INTERCEPT makes the following computation:
AVG (expression1) - REGR_SLOPE (expression1, expression2) * AVG (expression2)
• Without a window clause, REGR_INTERCEPT is a simple aggregate function.