[SQL]數值處理

ROUND(n, [m]) --四捨五入(m代表取到第幾位)

SELECT ROUND(5/3, 2) FROM DUAL;
=>1.67


SELECT ROUND(5/3, 0) FROM DUAL;
=>2



TRUNC(n, [m]) --無條件捨去(m代表取到第幾位)

SELECT TRUNC(5/3, 2) FROM DUAL;
=>1.66


SELECT TRUNC(5/3, 0) FROM DUAL;
=>1