group by rollup

SQL SERVER ROLLUP clause is used to display subtotals and grand totals in the result set . It is always used with Group By clause.