how to round 122.41 value to 122.40.
thank you.
SQL> select round(122.41,1) from dual;
ROUND(122.41,1)
---------------
122.4
The second argument to ROUND is how many decimal places.
1,2,3, = 1,2,3 decimal places
-1 = round to the tens
-2 = round to the hundreds
etc