EXCLUDE PART
You can specify a list of partitions, a range of partitions, or both. To specify a range of partitions, use the format x:y, where y is greater than x.
The list of partitions or ranges does not have to be in order. However, the list cannot contain duplicate partitions. For example, the following list is valid:
EXCLUDE PART (10,2:3,6)
But the following list is invalid:
EXCLUDE PART (10,2:3,2:6)
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*