查询条件:JE<>JE2
JE、JE2两个字段是SUM()得到的。原字段是float类型。
出现这个情况是不是在SUM()后小数位没显示全造成的呢?因为我讲JE、JE2转换成字符串再比较就没事了。我想问一下:如何避免出现这种情况。因为不可能在每次比较数值相等或不相等的时候都要转成字符来比较吧。
KS                                                 JE                     JE2
-------------------------------------------------- ---------------------- ----------------------
124                                                1526.46                1526.46
118                                                7465.5765              7465.5765
114                                                8130.5475              8130.5475
195                                                2624.99                2624.99
109                                                6392.943               6430.019
115                                                2314.824               2322.598