SQL ROUND, TRUNC Function - Round two decimal places
SQL ROUND Function
SQL ROUND function return the round number of specified nth number of decimal place.
Supported Oracle SQL Version
- Oracle 8i
- Oracle 9i
- Oracle 10g
- Oracle 11g
- Oracle 12c
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
SQL TRUNC Function
SQL TRUNC function return the truncated number of specified nth number of decimal place.
Supported Oracle SQL Version
- Oracle 8i
- Oracle 9i
- Oracle 10g
- Oracle 11g
- Oracle 12c
Syntax
TRUNC(n, decimal_number)
n is a number to return a truncated number and
decimal_number is specified nth of decimal place to a truncate.
Example
Consider following example take n number, return the square root of the number.
SQL> SELECT TRUNC(10.1234,1) "TRUNC" FROM DUAL;
TRUNC
----------
10.1
SQL> SELECT TRUNC(10.1234,2) "TRUNC" FROM DUAL;
TRUNC
----------
10.12
SQL> SELECT TRUNC(10.1234,3) "TRUNC" FROM DUAL;
TRUNC
----------
10.123