Archives of the TeradataForum

Message Posted: Fri, 29 May 2009 @ 19:46:45 GMT

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

SYNTAX:

     SEL CSUM(,  [ASC | DESC] [ [ASC |
     DESC]....)
     FROM 
     [GROUP BY  [, ....]]
     ;

EXAMPLE:

     SELECT PRODUCT
             ,DATE
             ,SALE
             ,CSUM(SALE, DATE) AS "CSUM"
     FROM TABLE
     WHERE PRODUCT BETWEEN 401 AND 500;

HOPE ITS HELP.

Regards,

Sabir, Mohammad

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