Grouping sets in MS SQL 2008

Set of groups by varying columns is called Grouping Sets. Grouping sets are equivalent to a Union All of quires.Microsoft introduce Grouping Sets in MS SQL 2008, it is introduce for developer to work easily. you can also use Union All if you not have MS SQL 2008 or later versions.