[SQL] 숫자함수 ROUND(), TRUNC(), MOD()

- Number Function

① ROUND : 반올림

ROUND (45.926, 2)

-> 45.93

ROUND (45.926, 1)

-> 45.9

ROUND (45.926, 0) , ROUND (45.926)

-> 46

ROUND (45.926, -1)

-> 50

ROUND (45.926, -2)

-> 0

② TRUNC : 절사

TRUNC (45.926, 2)

-> 45.92

TRUNC (45.926, 1)

-> 45.9

TRUNC (45.926, 0) , TRUNC (45.926)

-> 45

TRUNC (45.926, -1)

-> 40

TRUNC (45.926, -2)

-> 0

③ MOD : 나머지

MOD (1600, 300)

-> 100

④ 몫은? TRUNC() 이용

select MOD(1600,300), TRUNC(1600/300) from dual;