The round functions allows you to round up any number to a certain number of decimal places.
For example:
|
round(6.02,1) |
would return 6.0 |
|
round(6.789,2) |
would return 6.79 |
See Ceil to round numbers up to the nearest integer.
See Floor to round a number down to the nearest integer.
Round – Oracle SQL Function