The calculation `select (75/979.86)*979.86` in Teradata SqL gives 78.3888. In excel, it would give 75 simply and that is logically correct. I get it that SQL is rounding off 75/979.86 to 0.08 ie the number of decimal digits in 979.86. And hence the result is different.So, I can simply do (75\*979.86)/979.86 instead and get the result.But is there any way to match these exactly maybe by changing data type or rounding off?