SQL Data Analyst — Hard
Key points
- CUBE includes all possible combinations for specified columns
- ROLLUP generates a hierarchical subtotal
- CUBE offers more detailed data analysis
- ROLLUP provides a simpler subtotal view
Ready to go further?
Related questions