Re: filter partitions

Hi,

 

I wonder how could it be possible to extract partitions that contains a peculiar item

 

Consider 4 partitions 1, 2, 3, 4 with different items A, B, C... inside

 

P item

1 A

1 B

1 C

2 B

2 D

2 G

2 H

3 B

3 C

4 X

4 D

4 Z

 

 

How could a select return partitions 2,4 because they both contains D item ?

 

As a result, I would get :

 

2 B

2 D

2 G

2 H

4 X

4 D

4 Z

 

I can filter partitions with lag, lead, nth_value... but how could I write something like "select P,any (item=D) over (partition by P) from..."

 

Thanks for any help,

 

 

Garanti sans virus. www.avast.com