Oracle PL/SQL: COVAR POP - COVAR POP returns the population covariance of a set of number pairs. Both expr1 and expr2 are numer

Quick Search:

Oracle PL/SQL: COVAR_POP

Jump to:

Category: >> Oracle PL/SQL >> COVAR_POP

<< last

next >>

Snippet Name: COVAR_POP

Description: COVAR_POP returns the population covariance of a set of number pairs. Both expr1 and expr2 are numeric expressions. Virtuoso applies the function to the set of (expr1, expr2) pairs after eliminating all pairs for which either expr1 or expr2 is null. Then Virtuoso makes the following computation:

(SUM(expr1 * expr2) - SUM(expr2) * SUM(expr1) / n) / n

where n is the number of (expr1, expr2) pairs where neither expr1 nor expr2 is null.

Also see:
» BR2NL Function: Opposite of NL2BR
» A JavaScript implementation of the fam...
» Call a PHP function when clicking on a...
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: drop
» FUNCTIONS: Recompile
» FUNCTIONS: DEBUG mode
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» Recursive fopen() function
» INDEXES: ENABLE (function-based index)
» INDEXES: DISABLE (function-based index)
» PACKAGES: one function
» INDEXES: Function-Based Index
» IN Function
» Built-In Functions: CASE
» Built-In Functions: DECODE
» Alternate Title Case function
» SELECT: Using Functions
» RANK
» REGR_SLOPE

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 06th, 2009

COVAR_POP(<expression1>, <expression2>) OVER (<analytic clause>)
 
conn oe/oe
 
SELECT project_id,
COVAR_POP(SYSDATE-hire_date, salary) AS COVAR_POP,
COVAR_SAMP(SYSDATE-hire_date, salary) AS COVAR_SAMP
FROM employee_list
WHERE department_id IN (50, 80)
GROUP BY project_id;