Can I read Understanding ROLLUP and CUBE Operations on EtoBox?
Understanding ROLLUP and CUBE Operations by Deepak Yadav is a document available to read on EtoBox.
What is Understanding ROLLUP and CUBE Operations about?
The ROLLUP operation groups rows based on expressions in the GROUP BY clause and returns subtotals from the most detailed level to the grand total. It produces one more group than expressions. The CUBE operation groups rows based on all combinations of expressions and returns cross-tabulation values. It produces 2 to the power of the number of expressions groups. Both can be used with functions like SUM to generate superaggregates from a table.
- Author
- Deepak Yadav
- Language
- EN