我进行了一些测试。truncate(abs('414')/100,2)truncate('414'/100,2)truncate('4.14',2)truncate('4.1400',2)都有精度丢失。
TRUNCATE(cast(ABS(字符串)/100 as decimal(15,4)) ,2)上述方法,ABS(字符串)/100...
我进行了一些测试。truncate(abs('414')/100,2)truncate('414'/100,2)truncate('4.14',2)truncate('4.1400',2)都有精度丢失。
TRUNCATE(cast(ABS(字符串)/100 as decimal(15,4)) ,2)上述方法,ABS(字符串)/100...
链接:https://www.nowcoder.com/acm/contest/106/J
来源:牛客网
题目描述
It’s universally acknowledged that there’re innumerable trees in the campus of HUST.
And there are many different types of t...