Please help me with this cumbersome partitioning scenario
Need to partition a table based on following status value of a column - A,B,C,D
I want three partitions:
Partition1 --> Status Value (A,C)
Partition2 --> Status Value (B)
Partition3 --> Status Value (D)
How to do this?
I don't want to create a separate Partition for status value A and C