Skip to content
Advertisement

Round up to the next whole number case it contains decimal point (In SQL Oracle)

I need to retrieve a field from a table and display the results rounded up to the next whole number if is not whole yet.

For example:

I have in my table the field working hours.

I need to create de following logic.

Else select as it is (4.0).

Advertisement

Answer

Is this what you want?

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement