Different calculations in EXCEL and TERADATA SQL 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?
Teradata rounds after each calculation based on the resulting datatype (Standard SQL compliant), to get the expected reault you can either CAST the 1st operand to a NUMBER (no need to think about precision) and finally back to DECIMAL:

Cast((Cast(75 AS NUMBER)/979.86) *979.86 AS DECIMAL(10,2))


Ot you rearrange the order of calculation to multiply first and then divide:

979.86 * 75 / 979.86