CUBE and ROLLUP options in GROUP BY

For my actual project i am studying CUBE and ROLLUP option in GROUP BY.

These options are present from Oracle 8i and are very interesting :

ROLLUP

Rollup enables a SELECT statement to calculate multiple levels of subtotals across a specified group of dimension. Really is an extension of GROUP BY clause.

In this example are summarized totals and sales for Departments and Job Title with each totals for Department.

CUBE

Cube enables a SELECT statement to calculate subtotals for all possible combinations of a group of dimension.

In this example are summarized totals and sales for Departments and Job Title with each totals for Department and also for each job title.

Stay connected.