It creates grouping combinations in a hierarchical way based on the input columns

It returns the same result set you would obtain by using the CUBE clause with and same input columns

It creates a SUM from the unique column combination used in the clause

It creates subtotals and grand totals from all possible column combinations