Grouping Sets will be very much useful in basic reports that include aggregates, gives you more flexibility and performance . These are extension to CUBE and ROLLUP which exists in previous versions before 2008.
**CUBE:** Generates result set that con...