This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Which elements do you need to provide to the PIVOT operator?
Grouping, spreading, aggregation
Aggregation, cube, grouping
Spreading, grouping, viewing
Which subclause infers a hierarchy of columns to create meaningful grouping sets?
CUBE
GROUPING SETS
ROLLUP
You've pivoted a dataset with aggregation, what happens if you try to use UNPIVOT restore the original data?
Unpivoting can't restore the original data.
The data is unpivoted, and the original detail rows are restored.
The data is unpivoted, but you'll then need to use CUBE to restore the original detail rows.
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?