求助：这个SQL如何写？

[leon51]

要求找出下图中StepA和StepD出现了两次及以上的PartNumber
下图PartA中，StepA和SpepD各出现了一次，共两次；PartC中StepA共出现了3次; PartB中只出现了一次StepA。
因此结果应该是PartA和PartC.请问SQL应该怎么写?谢谢！

[卖水果的net]

select parNumber from t where step in ('A','D') group by parNumber having count(*) > 1

[nayi_224]

select PartNumber from temp_t group by decode(step, 'StepA', 'StepD', step) having count(1) > 1;

[leon51]

引用 1 楼 卖水果的net 的回复:

select parNumber from t where step in ('A','D') group by parNumber having count(*) > 1

版主威武

[leon51]

引用 2 楼 nayi_224 的回复:

select PartNumber from temp_t group by decode(step, 'StepA', 'StepD', step) having count(1) > 1;

多谢您的解答！

[weixin_44200964]

[with tmp as 
(
select 'PartA' as PartNumber,'StepA' as Step,1 as ording from dual
union all
select 'PartA' as PartNumber,'StepB' as Step,2 as ording from dual
union all
select 'PartA' as PartNumber,'StepC' as Step,3 as ording from dual
union all
select 'PartA' as PartNumber,'StepD' as Step,4 as ording from dual
union all
select 'PartB' as PartNumber,'StepA' as Step,1 as ording from dual
union all
select 'PartB' as PartNumber,'StepB' as Step,2 as ording from dual
union all
select 'PartB' as PartNumber,'StepC' as Step,3 as ording from dual
union all
select 'PartC' as PartNumber,'StepA' as Step,1 as ording from dual
union all
select 'PartC' as PartNumber,'StepA' as Step,2 as ording from dual
union all
select 'PartC' as PartNumber,'StepA' as Step,3 as ording from dual
)
select PartNumber,
       count(*) 
  from tmp
 where Step in ('StepA','SpepD')
 group by PartNumber
having count(*) >=2]