[DATABASE/DB2] ROUND 함수 : 반올림하기

■ ROUND 함수를 사용해 반올림하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    ROUND(873.726,  2)
   ,ROUND(873.726,  1)
   ,ROUND(873.726,  0)
   ,ROUND(873.726, -1)
   ,ROUND(873.726, -2)
   ,ROUND(873.726, -3)
   ,ROUND(873.726, -4)
FROM SYSIBM.SYSDUMMY1
WITH UR;

SELECT

ROUND(873.726, 2)

,ROUND(873.726, 1)

,ROUND(873.726, 0)

,ROUND(873.726, -1)

,ROUND(873.726, -2)

,ROUND(873.726, -3)

,ROUND(873.726, -4)

FROM SYSIBM.SYSDUMMY1

WITH UR;