Databases Reference
In-Depth Information
Which grouping sets you need to include in the query depends on the requirements
that you are trying to fulill. If you don't want a grand total, just leave out the empty
set. This is shown in the query in the following screenshot:
Now the result set will not show the grand total. The
GROUPING SETS
functionality
is very powerful.
Rollup
Rollups is a specialized type of grouping functions. Even though we have discussed
rollups before discussing grouping sets, when you understand the grouping sets the
Rollup
clause becomes very easy to grasp.