Round function for number rounded to specified integer to the right of the decimal point. It is a numeric function.
Syntax:-
ROUND(m,[n]) – n is optional
Example :-
SQL> select round(25.6) from dual;
ROUND(25.6)
———–
26
SQL> select round(25.4) from dual;
ROUND(25.4)
———–
25
Some more….
round(25.48,0) returns 25
round(25.48,1) returns 25.5
round(25.22,1) returns 25.2
round(25.48,2) returns 25.48
round(25.48,-1) returns 30
round(25.48,-2) returns 0
round(25.4876,1) returns 25.5
Advertisements
There seems to be a typo for last one which says
round(25.4876,1) returns 25 …..it would return 25.5
Typo fixed. Appreciate for pointing out.