Archives of the TeradataForum
Message Posted: Tue, 11 Dec 2012 @ 14:26:48 GMT
Kindly let me know answer of below question.
Question : Given the following reporting requirements:
* salary totals of each department
* a grand total of all departments
Which grouping function is designed to handle these requirements?
C. PARTITION BY
D. GROUP BY GROUPING SETS.
As per my knowledge, Cube, Rollup and Grouping sets will get the required result.
Kindly advise me which is most suitable.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|