oracle where 条件中用case

最新推荐文章于 2024-12-12 21:19:08 发布

iteye_3606

最新推荐文章于 2024-12-12 21:19:08 发布

阅读量1k

点赞数

文章标签：数据库

select  
 substr(xoq.item,2,5) model
from xwp_out_quantity xoq
where xoq.vendor='&s_vendor'
and (case when xoq.vendor='220010' then substr(xoq.item,2,1) else null end)=9
or  (case when xoq.vendor='220020' then substr(xoq.item,2,1) else null end)=8
or  (case when xoq.vendor='220030' then substr(xoq.item,2,1) else null end)=7