<< 참고 >>
[올림]
SQL> SELECT CEIL(132.4) 올림 FROM DUAL;
올림
-----------
133
1 rows selected.
-----------
133
1 rows selected.
[내림]
SQL> SELECT FLOOR(232.8) 내림 FROM DUAL;
내림
-----------
232
1 rows selected.
-----------
232
1 rows selected.
[반올림]
SQL> SELECT ROUND(422.8, 0) 반올림 FROM DUAL;
반올림
-----------
423
1 rows selected.
-----------
423
1 rows selected.