分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
select substr(xoq.item,2,5) modelfrom xwp_out_quantity xoqwhere xoq.vendor='&s_vendor'and (case when xoq.vendor='220010' then substr(xoq.item,2,1) else null end)=9or (case when xoq.vendor='220020' then substr(xoq.item,2,1) else null end)=8or (case when xoq.vendor='220030' then substr(xoq.item,2,1) else null end)=7