一句SQL找出组件相同的bom

       

 看下图bom结构,需求: 找出 A1 这份bom ,这个需求在工厂企业中很常见

select * from t29; 

最终实现效果

       

实现过程如下:

1.demo表结构创建

create table t29 as

with a as

(select 'A' bmb01, 'B1' bmb03

from dual

union all

select 'A' bmb01, 'B2' bmb03

from dual

union all

select 'A1' bmb01, 'B1' bmb03

from dual

union all

select 'A1' bmb01, 'B2' bmb03

from dual

union all

select 'A2' bmb01, 'B1' bmb03

from dual

union all

select 'A2' bmb01, 'C' bmb03 from dual)

select * from a

       

详细实现过程如下:

https://articles.zsxq.com/id_2xm2mbbzjrjr.html