Snippet Name: REGR_COUNT Description: REGR_COUNT Returns the number of non-null numbers used to fit the regression line. Parameters expr1 – Number expression. expr2 – Number expression. Also see:» RANK » REGR_SLOPE » VARIANCE » VAR_SAMP » VAR_POP » SUM » STDDEV_SAMP » STDDEV_POP » STDDEV » ROW_NUMBER » REGR_SYY » REGR_SXY » REGR_SXX » REGR_R2 » REGR_INTERCEPT » REGR_AVGY » REGR_AVGX » Number Functions: RATIO_TO_REPORT » Number Functions: RANK » PERCENTILE_DISC » PERCENTILE_CONT » PERCENT_RANK » OVER PARTITION BY » NTILE » MIN » MAX » LEAD » LAST_VALUE » LAST » LAG Comment: See REGR_AVGX Demo Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
Description: REGR_COUNT Returns the number of non-null numbers used to fit the regression line. Parameters expr1 – Number expression. expr2 – Number expression.
Also see:» RANK » REGR_SLOPE » VARIANCE » VAR_SAMP » VAR_POP » SUM » STDDEV_SAMP » STDDEV_POP » STDDEV » ROW_NUMBER » REGR_SYY » REGR_SXY » REGR_SXX » REGR_R2 » REGR_INTERCEPT » REGR_AVGY » REGR_AVGX » Number Functions: RATIO_TO_REPORT » Number Functions: RANK » PERCENTILE_DISC » PERCENTILE_CONT » PERCENT_RANK » OVER PARTITION BY » NTILE » MIN » MAX » LEAD » LAST_VALUE » LAST » LAG
Generic Syntax: FUNCTION_NAME (<expression1>,<expression2>) OVER (<analytic_clause>) conn oe/oe SELECT job_id, REGR_COUNT(SYSDATE-hire_date, salary) COUNT FROM employees WHERE department_id IN (30, 50) GROUP BY job_id;