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 vote202 views1 answer
Postgres convert date to string
SQL
0 vote183 views1 answer
Database springboot
SQL
0 vote206 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote184 views1 answer
Get records in sql according to month name and count
SQL
1 vote183 views1 answer
Mysql remove last empty newline
SQL
0 vote190 views1 answer
Como hacer una consulta en sql
SQL
10 votes147 views2 answers
Django mysql
SQL
1 vote178 views1 answer
Import in mysql without a software
SQL
3 votes192 views2 answers
How to start mysql in terminal
SQL
3 votes173 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL