WITH ROLLUP « Analytical Functions « SQL Server / T-SQL






1.WITH ROLLUP: WITH ROLLUP after the GROUP BY statement
2.WITH ROLLUP, group by and order by