The two at the bottom of the mathematical calculation of SQL, why different accuracy?
Select 1: : NUMERIC/6: : NUMERIC -- 0.16666666666666666667
Union all
Select: 5635272.0:130740.0/numeric: : numeric; -- -- -- -- -- 43.1028912345112437

CodePudding user response:

This depends on the realization of the different operating system restrictions, the results of the I is:
0.16666666666666666
43.10289123451124