那个我写出来了
select element1 from demo.nlmastm where (length(trim( replace(replace(element1,'-',''),'??','10')))=1 and element1 not in (select cost_code from demo.nlcostm )) or (length(trim( replace(replace(element1,'-',''),'??','10')))>=4 and substr(element1,0,4) not in (select cost_code from demo.nlcostm ));
select element1 from demo.nlmastm where (length(trim( replace(replace(element1,'-',''),'??','10')))=1 and element1 not in (select cost_code from demo.nlcostm )) or (length(trim( replace(replace(element1,'-',''),'??','10')))>=4 and substr(element1,0,4) not in (select cost_code from demo.nlcostm ));
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货