superaggregate

Rows based on the values of the first n expressions are called rows or regular rows and the others are called superaggregate rows.

Recently Uploaded Slideshows 2009

By using application or programming tools, these superaggregate values can then be fed into charts and graphs that convey results and relationships visually and effectively.

Recently Uploaded Slideshows 2009

GROUP BY with ROLLUP and CUBE Operators • Use ROLLUP or CUBE with GROUP BY to produce superaggregate rows by cross-referencing columns.

Recently Uploaded Slideshows 2009

If you have n columns or expressions in the GROUP BY clause, there will be 2n possible superaggregate combinations.

Recently Uploaded Slideshows 2009

The aggregate function specified in the select list is applied to these groups to produce summary values for the additional superaggregate rows.

Recently Uploaded Slideshows 2009

Example of a ROLLUP Operator In the example in the slide: Total salaries for every job ID within a department for those departments whose department ID is less than 60 are displayed by the GROUP BY clause (labeled 1) The ROLLUP operator displays: Total salary for those departments whose department ID is less than 60 (labeled 2) Total salary for all departments whose department ID is less than 60, irrespective of the job IDs (labeled 3) All rows indicated as 1 are regular rows and all rows indicated as 2 and 3 are superaggregate rows.

Recently Uploaded Slideshows 2009