SELECT ID FROM TABLE WHERE ID IN(select id from table where id='01') or ID in (select id from table wehre id = '011') or id In(select id from table where id='0111')初步想法,非常笨。身边也没有ORACLE。不知道能实现否。
select id from tbname start with id='0111' connect by prior parentid=id
select id from tbname start with id='0111' connect by prior parentid=id对,进行递增。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货