Archives of the TeradataForum

Message Posted: Fri, 18 Apr 2008 @ 22:40:19 GMT

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

Hi Lilian:

Here what I think might be happening:

The normal output data type from AVG is float. As far as I have seen, it is the only place where the data type coming out is not the same as the data type going into it.

On the second one, you are converting/forcing the float to a decimal attribute and getting more accuracy with the .25 versus the .00.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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