I would like to know if there is a way to round a number if it’s one decimal before 50.
I am using the below code and it works, it gives 8.50:
select Round(8.49,1) = 8.50
The problem comes when I want to round the below one, I would expect this one to be only 8.48 but results in 8.50 as well.
select Round(8.48,1) = 8.50
The idea is to keep the 8.48 as it is, but when it’s 8.49, it needs to be 8.50.