106. Which statement is true regarding the CUBE operator in the GROUP BY
clause of a SQL statement?
A. It produces only aggregates for the groups specified in the GROUP BY
clause.
B. It finds all the NULL values in the superaggregates for the groups
specified in the GROUP BY clause.
C. It produces 2 n possible superaggregate combinations, if the n columns
and expressions are specified in the GROUP BY clause.
D. It produces n+1 possible superaggregate combinations, if the n columns
and expressions are specified
in the GROUP BY clause.
Answer: C
Aggregates:集合 aggregate:合计 combinations:结合的
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718912/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
