CUBE, ROLLUP in SQL Server

Published: 21 March 2017
on channel: IT Port

919

Click here to Subscribe to IT PORT Channel : / @itport28

These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals

The ROLLUP operator is used with the GROUP BY clause. It is used to create subtotals and grand totals for a set of columns. The summarized amounts are created based on the columns passed to the ROLLUP operator

The CUBE operators, like the ROLLUP operator produces subtotals and grand totals as well. But unlike the ROLLUP operator it produces subtotals and grand totals for every permutation of the columns provided to the CUBE operator

On this page of the site you can watch the video online CUBE, ROLLUP in SQL Server with a duration of hours minute second in good quality, which was uploaded by the user IT Port 21 March 2017, share the link with friends and acquaintances, this video has already been watched 919 times on youtube and it was liked by 5 viewers. Enjoy your viewing!

47,717

1.5K

00:00:00