insert into test values (20.16666); insert into test values (32.2857 ); insert into test values (33.75 ); insert into test values (21.8 ); insert into test values (11.4 ); insert into test values (11.6 ); insert into test values (11.5 ); insert into test values (12.5 ); insert into test values (11.51 ); insert into test values (11.54321); insert into test values (11.50002); 执行 select price, case when substr(price,instr(price,'.')+1,1)=5 and mod(substr(price,instr(price,'.')-1,1),2)=0 then floor(price) else round(price) end from test; 结果