sql向上取整

⑴ sql 向上/向下取整的函数 是什么，

SELECT ceiling(4.1) AS 向上取整,floor(4.9) AS 向下取整,round(4.5,0) AS 四舍五入

⑵ sql中取整语句怎么写

1.绝对值
SQL:select abs(-1) value
O:select abs(-1) value from al
2.取整(大)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from al
3.取整（小）
S:select floor(-1.001) value
O:select floor(-1.001) value from al
4.取整（截取）
S:select cast(-1.002 as int) value
O:select trunc(-1.002) value from al
5.四舍五入
S:select round(1.23456,4) value 1.23460
O:select round(1.23456,4) value from al 1.2346

⑶ 弱问题，在sql中向上取整的函数是什么

【四舍五入取整截取】：select round(54.56,0)
【向下取整截取】：SELECT FLOOR(54.56)
【向上取整截取】：SELECT CEILING(13.15)

⑷ 如何让SQL server让字符串取整!

ceiling()是向上去整

select ceiling(123.3/5)*5,ceiling(178.8/5)*5

--------------------------------------- ---------------------------------------
125 180

(1 行受影响)