OLAP SQL Part 2 – CUBE

(Chris Eaton) Much like the rollup operator, the GROUP BY CUBE statement performs groupings on the columns listed to deliver subtotals and grand totals. The syntax is SELECT … FROM … WHERE … GROUP BY CUBE(column1,column2,..)

Read More - Register for Free Membership