mysql-case ... when...then...else...end处理判断赋值机制时间:2023-03-10 01:03:10 select stockcode,stockname,(zxj-(case zrspj when 0 then jrkp else zrspj end ))/(case zrspj when 0 then jrkp else zrspj end ) zdf from hqxg where stockcode like '_3%' and zxj-(case zrspj when 0 then jrkp else zrspj end )<0 order by zdf LIMIT 0,3;