select id,-(col2*(-1)+2)+(col4+4)(col1+col35),(5+col2)col33 from exp_table where -(col2*(-2)+8)+(col4+6)(col1+col39) > (5+col2)col39;
2 | 85.63 | 47.16
3 | 99.78 | 24.48
7 | 326.92 | 167.58
- 7 | 403.37 | 181.02
- 7 | 403.38 | 181.02
8 | 256.27 | 132
– below are some requests executed before(partial) –
– init data
create table exp_table(id int, col1 int, col2 int, col3 float, col4 float);
create table exp_table2(id int, col1 int);
insert into exp_table VALUES (8, 9, 5, 4.4, 4.17);
insert into exp_table VALUES (7, 3, 9, 3.99, 9.94);
insert into exp_table VALUES (7, 3, 2, 8.62, 4.75);
…
-(col2*(-1)+2)+(col4+4)(col1+col35)算出来是等于403.375：
-（2*（-1）+2）+（4.75+4）（3+8.625）=0+8.75*46.1=403.375
我的输出是403.38，答案显示是403.37.