70. Which two statements are true about the GROUPING function? (Choose two.)
A. It is used to find the groups forming the subtotal in a row.
B. It is used to identify the NULL value in the aggregate functions.
C. It is used to form. the group sets involved in generating the totals and
subtotals.
D. It can only be used with ROLLUP and CUBE operators specified in the GROUP
BY clause.
Answer: AD
The GROUPING function identifies superaggregate or aggregate rows
produced by a ROLLUP or CUBE operation in a SELECT . . . GROUP BY statement.
It returns a value of the NUMBER datatype, and its value is either a one (1)
or a zero (0).The GROUPING function is only valid in a SELECT statement that
uses a GROUP BY clause. While GROUPING may be used in a GROUP BY that doesn’t
include the ROLLUP or CUBE operation, it doesn’t produce anything meaningful
without those operators—it will always return a zero if ROLLUP and CUBE are
absent from the statement.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718849/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
