四舍五入的数字 round(列名，小数点位数)

select  sal as '原始数据', round(sal) as '四舍五入后的数据' ,round(sal,1) as '四舍五入1个小数点后的数据'from emp;