例如,如果您考虑以下示例。
100.00 - Original Number
33.33 - 1st divided by 3
33.33 - 2nd divided by 3
33.33 - 3rd divided by 3
99.99 - Is the sum of the 3 division outcomes
But i want it to match the original 100.00
我看到一种做法是将原数减去前两个商,结果就是第三个数字。现在,如果我把这三个数字取出来,就可以得到原数。
100.00 - Original Number
33.33 - 1st divided by 3
33.33 - 2nd divided by 3
33.34 - 3rd number
100.00 - Which gives me my original number correctly. (33.33+33.33+33.34 = 100.00)
在Oracle PL/SQL或函数中是否有一个公式可以实现这个功能?
提前致谢!
N/3,N/3,N-2(N/3)
? - Leeor