SQL之rand,round,floor,ceiling,cast小数处理函数

rand():取随机数,select rand() from T 结果:0.635811742495648

round():保留N位小数,四舍五入 select round(1.0446,N) 

floor():舍掉小数 select floor(123.756) 结果:123

ceiling():向上舍入为指定小数位数 select ceiling(1.0756) 结果:2

cast():转换数据类型,select cast(1.7446 as int) 其参数是一个表达式

floor()向下舍入为指定小数位数 如：floor(1.45,0)= 1;floor(1.55,0) = 1