Summarizing Data with ROLLUP, CUBE, GROUPING SETS, COMPUTE and COMPUTE BY
Its very common, The GROUP BY statement to is used to summarize data, is almost as old as SQL itself. Microsoft introduced additional paradigm of ROLLUP and CUBE to add power to the GROUP BY clause…
