Statistical Functions
Oracle has added a variety of statistical functions to its database. Statistics such as correlation, covariance, and linear regression can be computed. The functions operate on unordered result sets, and they can be used with the windowing function. Table 9.2 describes the available functions
The use of the various functions is depicted in Listing 9.22. The functions are used to analyze the employee Wages values.
| Function Name | Description |
|---|---|
| VAR_POP | Computes the population variance of a number set after discarding all null values |
| VAR_SAMP | Computes the sample variance of a number set after discarding the null values (This function is similar to the VARIANCE function. The difference occurs when ... |
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
