ROLLUP(expr)
ROLLUP(expr)
Calculates n + 1 aggregates for n number of columns in
exprCUBE(expr)
CUBE(expr)
Calculates 2n aggregates for n number of columns in
exprGROUPING SETS(expr)
GROUPING SETS(expr)
Calculates aggregates for any given aggregates in
expr, including ROLLUP() and
CUBE()