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

1 vote297 views1 answer
Update foreign key value in mysql
SQL
0 vote268 views1 answer
Sql combine results from two tables
SQL
4 votes289 views4 answers
Rollback in sql
SQL
0 vote309 views1 answer
Dataframe lambda elif
SQL
0 vote272 views1 answer
Postgres in operator with comma separated values
SQL
0 vote279 views1 answer
Exec procedure oracle
SQL
0 vote324 views1 answer
Sql to excel pgadmin
SQL
0 vote297 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
-1 vote260 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote281 views2 answers
How do I install microsoft SQL on my Mac?
SQL