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

icodebroker DB2 2024-06-18

■ 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;

1

2

3

4

5

6

7

8

9

10

11

12

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;