This is the third part of the series about Oracle's Analytic Functions. Oracle Analytic Functions are functions that are similar to their respective aggregate function, but instead of returning a single record per group, there are multiple rows per group.

So far we have covered:
Introduction To Oracle's Analytic Functions
Oracle's COUNT Analytic Function

In this part we will cover the SUM analytic function. The SUM analytic function returns the summarized value of a given field (or expression) returned by the query.

This is the second part of the series about Oracle's Analytic Functions. Oracle Analytic Functions are functions that are similar to their respective aggregate function, but instead of returning a single record per group, there are multiple rows per group.

So far we have covered:
Introduction To Oracle's Analytic Functions

In this part we will cover the COUNT analytic function. The COUNT analytic function returns the number of rows returned by the query.

As a Data Warehouse Engineer in the Data Warehouse team for a large MLM (Multi Level Marketing) company it has become obvious to me that knowledge about Oracle's Analytic Functions is essential.

These analytic functions have become a part of the workday in the kind of reporting and analysis we do on a daily basis.

In this tutorial I will try to explain to you how to use them, through practical examples. You will probably have problems following this tutorial if you do not have knowledge about Oracle's aggregated functions...