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