Hi Bensr,

There are quarterly partition for the current year and another partition for previous years data.

So, how to enforce the query to look into only those partitions where data satisfying the condition exist?

Thanks,