A表========== B==========
1 100 1 100
1 100 1 100
1 100 1 100
1 100 2 200
1 100
2 200
2 200
3 300
...
查询出来结果
1 100
1 100
2 200
3 300
..
------解决方案--------------------
with A as
(
select 1 a,100 b from dual union all
select 1,100 from dual union all
select 1,100 from dual union all
select 1,100 from dual union all
select 1,100 from dual union all
select 2,200 from dual union all
select 2,200 from dual union all
select 3,300 from dual
),
B as
(
select 1 a,100 b from dual union all
select 1,100 from dual union all