Archives of the TeradataForum

Message Posted: Mon, 08 May 2006 @ 09:50:58 GMT

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

Rao:

For all aggregation except AVG Teradata uses the data type of the column you reference. Therefore, if you are using an INT data column as soon as you exceed 2GB it will overflow. Use the following:

     SUM(columnname(DEC(15,0))

Hope this helps you,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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