题解 | 基本数学函数

select 
id,
value,
case when value >= 0 then value
     when value < 0 then value *-1
     end as absolute_value,
ceil(value) as ceiling_value,
floor(value) as floor_value,
round(value,1) as rounded_value
from numbers ;