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

4 votes332 views1 answer
To date oracle with time
SQL
0 vote341 views1 answer
Syntax for changing column size in mysql
SQL
10 votes320 views2 answers
Sql where clause multiple values
SQL
-2 votes329 views2 answers
Sqlserver docker
SQL
0 vote404 views1 answer
Mysql insert multiple rows based on select
SQL
4 votes334 views1 answer
Select first and last row sql
SQL
0 vote364 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote368 views2 answers
Select into temp table
SQL
0 vote292 views1 answer
Update sql join multiple tables
SQL
0 vote338 views1 answer
Sqlalchemy case insensitive like
SQL