rollUP to display total and grand total

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