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 vote104 views1 answer
Sql server set complex constraints
SQL
0 vote104 views1 answer
Implizite joins sql
SQL
0 vote106 views1 answer
Systemverilog unique constraint unique values
SQL
1 vote108 views2 answers
Maximum number of tables in mysql
SQL
0 vote112 views1 answer
Search starting with mysql
SQL
0 vote109 views1 answer
Virtuoso sql query tutorial
SQL
6 votes102 views1 answer
Postgres get size of database
SQL
0 vote126 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote105 views1 answer
Select password from user mysql
SQL
0 vote193 views1 answer
Which MySQL data type to use for storing boolean values
SQL