Archives of the TeradataForum

Message Posted: Tue, 29 Nov 2011 @ 12:44:04 GMT

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

<-- Anonymously Posted: Tuesday, November 29, 2011 06:05 -->

This is how my query will look like.

     SELECT "T0"."C0" , "T0"."C1"  , "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5",  "T0"."C6",
     "T0"."C7", "T0"."C8",  "T0"."C9" ,  "T0"."C59" , "T0"."C60", "T0"."C61", "T0"."C62",
     "T0"."C63" ,
            SUM ( "T0"."C59" ) OVER ( ), SUM ( "T0"."C60" ) over(),
              SUM ( "T0"."C61" ) OVER ( ),
              SUM ( "T0"."C62" ) OVER (), SUM ( "T0"."C63" ) OVER ()
             FROM

                ( SELECT col1 (NAMED "C0" ) , col2 (NAMED "C1" ) , col3 (NAMED "C2" ) , col4
     (NAMED "C3" ) , col5 (NAMED "C4" ) ,
                  Col6 (NAMED "C5" ) , col7 (NAMED "C6" ) , col8 (NAMED "C7" ) ,
               col9 (NAMED "C8" ) , col10 (NAMED "C9" ) ,
                            SUM ( col10 ) (NAMED "C59" ) ,
                            SUM ( col11 ) (NAMED "C60" ) ,
                            SUM (col12 ) (NAMED "C61" ) ,
                            SUM ( col13 ) (NAMED "C62" ) ,
                            SUM ( col14 ) (NAMED "C63" ) FROM
                             Tbl1     INNER JOIN ( SELECT  id  FROM Tbl ) tbl2 ON
                               Tbl2.id = tbl1.c5 GROUP BY
     Col1,col2,col3,col4,col5,col6,col7,col8,col9,col10) "T0"

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