SQL for Analysis - Oracle Help Center
文章推薦指數： 80 %
CUBE enables a SELECT statement to calculate subtotals for all possible combinations of a group of dimensions. It also calculates a grand total. This is the set ... Oracle8iDataWarehousingGuideRelease2(8.1.6)PartNumberA76994-01 Library Product Contents
延伸文章資訊
- 1Analyzing Data with ROLLUP, CUBE, AND TOP-N QUERIES
To handle these issues, Oracle 8i introduces a new function called GROUPING . Using a single colu...
- 2SQL for Analysis - Oracle Help Center
CUBE enables a SELECT statement to calculate subtotals for all possible combinations of a group o...
- 3Oracle Analytical SQL functions - rollup - cube - Remote DBA
CUBE enables a SELECT statement to calculate subtotals for all possible combinations of a group o...
- 420 SQL for Aggregation in Data Warehouses - Oracle Help ...
- 520 SQL for Aggregation in Data Warehouses - Oracle Help ...
CUBE is an extension similar to ROLLUP , enabling a single statement to calculate all possible co...
