SQL ROUND() Function

SQL ROUND() function return the round number of specified nth number of decimal place.

SQL ROUND() function supported SQL version

Oracle 8i
Oracle 9i
Oracle 10g
Oracle 11g
Oracle 12c
Oracle 18c

Syntax

ROUND(n, decimal_number)

n is a number to return a round number and
decimal_number is specified nth of decimal place to a rounded.

Example

Considering following example SQL ROUND function.

SQL> SELECT ROUND(10.5454,2) "Round" FROM DUAL;

     Round
----------
     10.55

SQL> SELECT ROUND(5.1234,2) "Round" FROM DUAL;

     Round
----------
      5.12

SQL> SELECT ROUND(5.999,1) "Round" FROM DUAL;

     Round
----------
         6

SQL> SELECT ROUND(5.8989,1) "Round" FROM DUAL;

     Round
----------
       5.9