SQL取整、四舍五入

SELECT ROUND(3.6,0 ) as 四舍五入4;
SELECT ROUND(3.2,0 ) as 四舍五入3;
SELECT ROUND(3.26,1) as 四舍五入3.3;
round需要一个位数的参数

SELECT FLOOR(1.4) as 向下取整1;
SELECT FLOOR(1.6) as 向下取整1;

SELECT CEILING(1.3) as 向上取整2;
SELECT CEILING(1.8) as 向上取整2;

floor和ceiling都取到整数，不含小数