Results for COVAR_POP


1 to 10 of 10 results.


SQL Reference, 10g Release 1 (10.1)

COVAR_POP

COVAR_POPSyntax covar_pop::= Description of the illustration covar_pop.gif See Also: "Analytic Functions … " for information on syntax, semantics, and restrictions Purpose COVAR_POP returns the population … units sold for each year from the sample table sh.sales: SELECT t.calendar_month_number, COVAR_POP … (s.amount_sold, s.quantity_sold)

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

REGR_SXX, REGR_SYY, and REGR_SXY Functions(e1,e2) * VAR_POP(e1) REGR_SXY: REGR_COUNT(e1,e2) * COVAR_POP(e1, e2)

SQL Reference, 10g Release 1 (10.1)

COVAR_SAMP

COVAR_SAMPExample Please refer to the aggregate example for COVAR_POP. Analytic Example Please refer to the analytic example for COVAR_POP.

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

Linear Regression Functionsfrequently combined with the COVAR_POP, COVAR_SAMP, and CORR functions.

SQL Reference, 10g Release 1 (10.1)

SQL Functions

Aggregate Functionsfunctions are: AVG COLLECT CORR CORR_* COUNT COVAR_POP COVAR_SAMP CUME_DIST DENSE_RANK FIRST GROUP_ID

SQL Reference, 10g Release 1 (10.1)

CORR

CORRfollowing computation: COVAR_POP(expr1, expr2) / (STDDEV_POP(expr1) * STDDEV_POP(expr2)) The function

SQL Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL Functions) COSH COSH(n) COUNT COUNT({ * | [ DISTINCT | ALL ] expr }) [ OVER (analytic_clause) ] COVAR_POPCOVAR_POP(expr1, expr2) [ OVER (analytic_clause) ] COVAR_SAMP COVAR_SAMP(expr1, expr2) [ OVER

SQL Reference, 10g Release 1 (10.1)

REGR_ (Linear Regression) Funct ion s

REGR_ (Linear Regression) Functionsthe following computation: COVAR_POP(expr1, expr2) / VAR_POP(expr2) REGR_INTERCEPT returns the y … ) pairs: REGR_COUNT(expr1, expr2) * COVAR_POP(expr1, expr2) The following examples are based on the

SQL Reference, 10g Release 1 (10.1)

SQL Functions

Notes on the analytic_clause :windowing_clause. AVG * CORR * COVAR_POP * COVAR_SAMP * COUNT * CUME_DIST DENSE_RANK FIRST

SQL Reference, 10g Release 1 (10.1)

Contents

ContentsCOVAR_POP COVAR_SAMP CUME_DIST CURRENT_DATE CURRENT_TIMESTAMP CV DBTIMEZONE DECODE DECOMPOSE DENSE_RANK


Was this page helpful?