GROUP BY (Transact-SQL)

One row with a subtotal is generated for each unique combination of values of (a, b, c), (a, b), and (a). A grand total row is also calculated. Columns are rolled up from right to left. The column order affects the output groupings of ROLLUP and can affec

msdn.microsoft.com