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 vote207 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote198 views2 answers
How to get last inserted id in sql server c#
SQL
1 vote193 views1 answer
GROUP BY clause; this is incompati
SQL
2 votes291 views1 answer
Sql missing records from another table
SQL
0 vote254 views1 answer
Postgresql create table default value timestamp
SQL
3 votes194 views1 answer
Null sql
SQL
0 vote204 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote226 views1 answer
Psql store procedure-return multiple table values
SQL
4 votes186 views1 answer
What are the data types in sql
SQL
0 vote218 views1 answer
Psql generate id in existing database
SQL