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, |
