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

2 votes302 views1 answer
Capitalize 1st letter in sql server
SQL
10 votes249 views2 answers
Sql merge statement
SQL
0 vote274 views1 answer
Mysql cli output to a file
SQL
0 vote243 views2 answers
Select limit ms sql
SQL
13 votes242 views2 answers
Sqlite rename column
SQL
0 vote206 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote249 views1 answer
Como hacer una consulta en sql
SQL
0 vote266 views1 answer
Compare two tables to find unmatched records
SQL
0 vote265 views1 answer
Sql dmv to capture updates
SQL
6 votes264 views2 answers
What is non relational database
SQL