Round



ROUND
**__Function Arguments: __** ROUND(column|expression, decimal places) ROUND(45.926,2) 45.93 ROUND(45.926,-1) 50 __Description:__ Round can be used with both numbers and dates. It is mainly used to round numbers to a specified number of decimal places, but it can also be used to round numbers to the left of the decimal point. __Examples: __

FROM dual

 * ROUND(74.840,2) ||
 * 74.84 ||


 * ROUND(85.400,-1) ||
 * 90 ||

FROM employees

 * ROUND(45.926,0) ||
 * <span style="color: #000000; font-family: 'Courier New', Courier, monospace;">46 ||