cube oracle
-- In addition to the regular aggregation results we expect from the
-- GROUP BY clause, the ROLLUP extension produces group subtotals from
-- right to left and a grand total. If "n" is the number of
-- columns listed in the ROLLUP, there will be n+1 levels of subtotals.
SELECT fact_1_id,
fact_2_id,
fact_3_id,
SUM(sales_value) AS sales_value
FROM dimension_tab
GROUP BY ROLLUP (fact_1_id, fact_2_id, fact_3_id)
ORDER BY fact_1_id, fact_2_id, fact_3_id;
0
8
-- the CUBE extension will generate subtotals for all combinations of the
-- dimensions specified. If "n" is the number of columns listed in the CUBE,
-- there will be 2^n subtotal combinations.
SELECT fact_1_id,
fact_2_id,
fact_3_id,
SUM(sales_value) AS sales_value
FROM dimension_tab
GROUP BY CUBE (fact_1_id, fact_2_id, fact_3_id)
ORDER BY fact_1_id, fact_2_id, fact_3_id;
Thank you!
8
0
0
Are there any code examples left?
New code examples in category SQL
Relative searches
cube in oracle
oracle cube
cube function performs increasing levels of cumulative subtotals, based on the provided column list.
(ii)Write a SQL query that returns the count of employees by region, country, state and department. (iii)Add a ROLLUP clause to the query in (ii) and comment on the results.
grouping sets in oracle
What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.
oracle sql rollup
rollup only certain combinations
DO CUBE RETURN THE GRAND TOTAL
oracle rollup
rollup oracle
The SQL ROLLUP operator shows * The complete set of subtotals. A partial set of subtotals appropriate for columns related as a hierarchical dimension.
by running following rollup how many groupingsare possibe
Why Groupid() clause is used in OLAP queries?
rollup in oracle
cube oracle
roll up oracle
