The round functions allows you to round up any number to a certain number of decimal places.

For example:


would return 6.0


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
Tagged on: