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

3 votes182 views1 answer
Set default today mysql
SQL
4 votes185 views4 answers
Oracle tablespace tables list
SQL
1 vote189 views2 answers
Laravel get sql query eloquent with parameters
SQL
-1 vote185 views1 answer
Io
SQL
5 votes174 views1 answer
Oracle list packages
SQL
0 vote201 views1 answer
Sql gather statistics to increase performance
SQL
0 vote178 views1 answer
Set a default value for a column in sqlite
SQL
0 vote169 views1 answer
Mysql to get column name in database
SQL
0 vote189 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote196 views1 answer
Create a view in sqlite
SQL