Cube oracle

 -- 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;

Source: oracle-base.com

Similar codes

5 votes252 views1 answer
Mysql count lines
SQL
0 vote195 views1 answer
Mysql select last 15 minutes
SQL
1 vote191 views1 answer
Mysql show data from table
SQL
4 votes201 views4 answers
What is primary key
SQL
0 vote210 views1 answer
Sql query contains multiple ids
SQL
0 vote192 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote209 views1 answer
Ms sql filter all sympbol
SQL
0 vote218 views1 answer
Creating a simple notify in postgresql
SQL
2 votes208 views2 answers
Postgresql search all tables for column name
SQL
1 vote202 views3 answers
Postgresql crete view
SQL