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;
2022-10-30 21:33:26
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;