小数点后保留一位小数
create table tb(val decimal(18,2))insert into tb values(18.2)insert into tb values(18.23)insert into tb values(18.24)goselect val , cast((case when val*10 - floor(val*10) > 0 then floor(val*10) + 1 el
