I have carefully tested the problem above and I have found no answers yet.
But I can add information to clarify the problem:
Because integer numbers are supposed to give the same sum if added in no matter what particular order, the ORDER BY above should NOT modify the result.
The strange thing is that it does change the result.
It looks like all the records are skipped except the last one !
Before giving any quick answer, kindly please try to understand deeply the problem and test it in various ways, not only the one in the example above. The meaning is very deep and obvious at the same time.
No comments:
Post a Comment