Databases Reference
In-Depth Information
In this query, the irst part—lines 1 through 4—the
GROUP BY
set consists of
empno
.
The second part of the query—lines 6 through 8—consists of groups on an empty set.
To get the same results, you can combine these two separate statements by using a
single
GROUP BY
clause with the
GROUPING SETS
keyword.