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 vote315 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote315 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
24 votes325 views4 answers
Delete db postgres
SQL
-1 vote317 views1 answer
How to switch user in mysql
SQL
3 votes328 views2 answers
Oracle privileges users
SQL
0 vote315 views1 answer
Mariadb hours between two dates
SQL
2 votes343 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote361 views2 answers
How to install psql in ubuntu
SQL
1 vote319 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote331 views1 answer
Get initials name in sql
SQL