Average value difference in BTEQ and Teradata SQL Assistant.

General
Enthusiast

Average value difference in BTEQ and Teradata SQL Assistant.

Hi,

I'm running a query to find the average in BTEQ and its datatype is Decimal(10,2). If my original result value is 51.5065, BTEQ returns the value as 51.50 and when I run the same query in Teradata SQL assistant, it returns 51.51. Why there is a difference in BTEQ and Teradata SQL Assistant.?. Please help me on this.

Thanks,

Vinay.