Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Cube, Rollup and Grouping sets
 
From:   sughesh iyyani

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016