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

24 votes114 views4 answers
How to add column sql
SQL
1 vote159 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote107 views2 answers
Search stored procedures
SQL
1 vote117 views1 answer
Mysql get latest duplicate rows
SQL
0 vote103 views1 answer
Postgresql inline table
SQL
4 votes117 views2 answers
Xampp mysql database server is not starting mac m1
SQL
1 vote75 views1 answer
Postgresql last element of array
SQL
0 vote115 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
9 votes112 views1 answer
Mysql check date range
SQL
2 votes121 views3 answers
Mysql pass command from command line
SQL