FILTER
Short Description
The FILTER operator indicates the use of a filter to reduce the number of rows returned
Detailed Description​
The FILTER operator indicates the use of a filter to reduce the number of rows returned by matching a supplied predicate.
DB2 recommends the use of joins rather than subqueries. Ensure your query optimization class is at least 3. If this is not possible, eliminate the subquery by rewriting your query.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.