比如 SAFETYSTOCK*0.9<QTY<SAFETYSTOCK*1.1 在QTY这个值范围之内 为 1 如果大于2 小于 3
SELECT s.FNUMBER,s.SAFETYSTOCK,y.QTY
FROM MC_INVENTORY_SECURITY s left join MC_INVENTORY_QTY y on y.ITEMCODE=s.FNUMBER
SELECT s.FNUMBER, s.SAFETYSTOCK, y.QTY, case when y.QTY between s.SAFETYSTOCK*0.9 and s.SAFETYSTOCK*1.1 then 1 when y.QTY>s.SAFETYSTOCK*1.1 then 2 else 3 endFROM MC_INVENTORY_SECURITY s left join MC_INVENTORY_QTY y on y.ITEMCODE=s.FNUMBER
然后呢?
select * from talbe
where
A < B
AND
B < C
打个比方:select A,B, (case when A>B then 1 when A<B then 2 else 0 end)as C from dual