1、直接相除 select 14/6 as part1 结果 part1=2 2、加入cast 相除 select cast((14/6) as float) as part2 结果 part2=2 3、加入cast相除,除数乘以1.0 select cast((14*1.0/6) as float) as part3 结果 part3=2.33333 4、加入round来控制小数点位数 select round(cast((14*1.0/6) as float),2) as part4 结果 part4=2.33