3,494
社区成员




select code, list
from (select code,
list,
row_number() over(order by abs(length('ABCDEF') - length(list))) rn
from (select code, list
from test
where 'ABCDEF' like '%' || list || '%'))
where rn = 1
union all
select code, list
from (select code,
list,
row_number() over(order by abs(length('BCBD') - length(list))) rn
from (select code, list
from test
where 'BCBD' like '%' || list || '%'))
where rn = 1;