Results for COVAR_SAMP


1 to 7 of 7 results.


SQL Reference, 10g Release 1 (10.1)

COVAR_SAMP

COVAR_SAMPSyntax covar_samp::= Description of the illustration covar_samp.gif See Also: "Analytic Functions … " for information on syntax, semantics, and restrictions Purpose COVAR_SAMP returns the sample

SQL Reference, 10g Release 1 (10.1)

COVAR_POP

COVAR_POP(s.amount_sold, s.quantity_sold) AS covar_pop, COVAR_SAMP(s.amount_sold, s.quantity_sold) AS … covar_samp FROM sales s, times t WHERE s.time_id = t.time_id AND t.calendar_year = 1998 GROUP BY … t.calendar_month_number; CALENDAR_MONTH_NUMBER COVAR_POP COVAR_SAMP … , min_price) OVER (ORDER BY product_id, supplier_id) AS CUM_COVP,

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 Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL FunctionsCOVAR_POP(expr1, expr2) [ OVER (analytic_clause) ] COVAR_SAMP COVAR_SAMP(expr1, expr2) [ OVER

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?