round,ceiling 2 decimal points

Question

I want to round up some figures that have 2 decimals points to 1. However, I always want it to round 1 examples of the list of figures in column amount

140.08 = 140.1
141.63 = 141.7

if I use round(141.63,1) it equals 142.6, but I want all the decimal points to round up, similar to the ceiling function. I want 141.7

Any help would be great?

thanks Don

you should do one thing, whatever result you have, just pass it in ' ' by using ROUND (' ', 1). — Yogesh Sharma, Oct 06 '17 at 06:04

score 13 · Accepted Answer · answered Oct 06 '17 at 05:55

13

you can try this.

select ceiling(141.63 * 10) / 10.0 ,
       ceiling(140.08 * 10) / 10.0

Result

141.700000                              
140.100000

answered Oct 06 '17 at 05:55

Serkan Arslan

13,158
4
29
44

Thanks for the help. Cheers Don – Don Mercer Oct 06 '17 at 07:12
1

A bit weird that Round doesn't allow to chose rounding up/down, and Celing/Floor don't allow decimal places. Great work around. – CyberClaw Aug 17 '21 at 16:45

round,ceiling 2 decimal points

1 Answers1