Group by ROLLUP and CUBE

ROLLUP and CUBE are syntactic shortcuts that specify common grouping prefixes.

• Group by ROLLUP
  The ROLLUP operator requires an ordered list of grouping expressions to be supplied as arguments.
• Group by CUBE
  The CUBE operator in the GROUP BY clause analyzes data by forming the data into groups in more than one dimension (grouping expression).