I am using the average function to find the average of column having many rows. Each time i execute the query i get different result sets. The change is very small in precision. Ex. 16.12345678 and 16.12345679. Why do i see this change? Am i making some mistake here or is it something with Teradata? Please help.
the resulting datatype of an AVG is a FLOAT.
What's the datatype of the base column?
You can rewrite an any AVG(column) using SUM(column) / COUNT(column) which will use the original type (but might have to cast it to a higher number of digits).