Re: filter partitions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Oliver,

You can use the below query to get output for filtering table partition 2,4.

select p,item from parent_table where item='D' and p in (2,4) group by p,item;

Hope this helps.



On Tue, Feb 13, 2018 at 8:37 PM, Olivier Leprêtre <o.lepretre@xxxxxxxxx> wrote:

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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux