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 vote215 views1 answer
Django mssql backend
SQL
0 vote207 views3 answers
Duplicate row mysql
SQL
2 votes228 views1 answer
Sql update \
SQL
0 vote195 views1 answer
What is SQL data store?
SQL
0 vote286 views1 answer
Run docker container with database as rds metabase
SQL
0 vote194 views1 answer
Suse status MySQL
SQL
0 vote218 views1 answer
Rows, INSERT INTO, Returning
SQL
2 votes190 views1 answer
Oracle number to percentage
SQL
0 vote201 views1 answer
Test connection to sql server
SQL
1 vote202 views1 answer
Spark sql concatenate string and int
SQL