How to ROUND up digit after decimal point

Question

Recently I found a problem in my SQL code, which provides me with bad output (because of my fault of course). So the problem is that I want to specifically ROUND UP after decimal point, specifically I want 4.802 to become 4.9, similarly 5.210 to become 5.3

ROUND itself is not sufficient in this case

I want 4.802 to become 4.9, similarly 5.210 to become 5.3

Thanks much

Answer 1

you can use

ROUND( number [, decimal_places] )

similar functions are

CEIL( number )

and

FLOOR( number )