3,491
社区成员
发帖
与我相关
我的任务
分享
USE Excel;
GO
SELECT F1,LEFT(ROUND(F3,3),5),LEFT(ROUND(F5,3),5),LEFT(ROUND(F7,3),5),LEFT(ROUND(F9,3),5),LEFT(ROUND(F11,3),5)
FROM excel;
GO
USE Excel;
GO
SELECT F1,LEFT(ROUND(F3,3),5),LEFT(ROUND(F5,3),5),LEFT(ROUND(F7,3),5),LEFT(ROUND(F9,3),5),LEFT(ROUND(F11,3),5)
FROM excel;
GO
--数字四舍五入
SQL> select round(0.60629152154,4) from dual;
ROUND(0.60629152154,4)
----------------------
0.6063
--oracle 中截取小数点后面的数是这样的
SQL> select trunc(0.60639152154,4) from dual;
TRUNC(0.60639152154,4)
----------------------
0.6063
SQL> select trunc(0.6069152154,4) from dual;
TRUNC(0.6069152154,4)
---------------------
0.6069