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

0 vote185 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
5 votes198 views1 answer
How to check port number for postgresql
SQL
0 vote173 views1 answer
Mysql set boolean default value
SQL
5 votes164 views1 answer
Minecraft java port number
SQL
0 vote163 views2 answers
Sqlite
SQL
-1 vote175 views1 answer
Concat two columns in sql server
SQL
16 votes177 views2 answers
Sql exists
SQL
1 vote167 views2 answers
Mysql extract month
SQL
8 votes215 views2 answers
Python simple connect to mysql
SQL
0 vote173 views1 answer
Restore backup mysql .gz
SQL