how to use group by rollup feature of sql in the view creation sql tab of tdv studios What is the keyword/ syntax for it

[kokila vijayasree]

SELECT CASE GROUPING(A) WHEN 1 THEN 'Aa' ELSE A END AS RELATIVE_TIME_CATEGORY, S.B AS B, CASE GROUPING© WHEN 1 THEN 'Cc' ELSE C END AS C, SUM(D) AS NBR_of_DFROM Table_A A INNER JOIN Table_B RELTIME ON RELTIME.DTE_YRWK_NR_KPN=A.DTE_YRWK_COLL INNER JOIN Table_C S ON A.COU_STE_ID = S.STE_IDGROUP BY ROLLUP( A, B, C)