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 vote329 views3 answers
Union SQL
SQL
0 vote298 views1 answer
Sql insert tuple
SQL
0 vote294 views1 answer
How to print out column name differently in mysql
SQL
15 votes299 views2 answers
Open postgress in terminal mac
SQL
0 vote297 views1 answer
Can sqldatareader be null
SQL
2 votes292 views1 answer
Get first 3 letters name in sql
SQL
8 votes296 views2 answers
Mysql query dates between two dates
SQL
0 vote300 views1 answer
Drop column from table if exist on live server mysql
SQL
4 votes320 views2 answers
Dbms output
SQL
1 vote287 views1 answer
Mysql column start with string
SQL