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 vote160 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote279 views5 answers
Right join
SQL
0 vote172 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote170 views1 answer
Sqlalchemy sequence postgresql
SQL
1 vote171 views1 answer
Mysql not supported auth mode
SQL
2 votes169 views1 answer
Mysql time ago difference
SQL
0 vote191 views1 answer
Mysql url
SQL
0 vote179 views1 answer
Hoq to import database source
SQL
0 vote187 views3 answers
Condition in count sql
SQL
0 vote150 views1 answer
Mysql workbench search all tables
SQL