3,494
社区成员




with t as
(select '1002' c1
from dual
union all
select '100201' c1
from dual
union all
select '1002018523532' c1
from dual
union all
select '100201435X46413' c1
from dual
union all
select '100202' c1
from dual
union all
select '1002026335332' c1
from dual
union all
select '2001' c1
from dual
union all
select '200101' c1
from dual
union all
select '200102' c1
from dual)
select c1,
decode((select count(*)
from t t2
where t2.c1 like t1.c1 || '%'
and t2.c1 <> t1.c1),
0,
0,
1)
from t t1;