加条件分母为0直接显示0,不然就相除select (case column1 when '0' then '0' else column1/column2 end) as a from table
select (case when f2=0 then 0 else (f1/f2) end) from tb_name;--一般用case when 避免
