Archives of the TeradataForum

Message Posted: Tue, 11 Dec 2012 @ 14:26:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Experts,

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?

A. CUBE

B. ROLLUP

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.

Thanks,

Sughesh.

	<Prev	Next>		<<First	<Prev	Next>	Last>>