Filter
Top Products
STOCK table for which ITMNO is 100 or greater or WHCODE is 1 are fetched.
Example 3:
In this example, the logical operator "NOT" is specified in the search condition. The rows from the
STOCK table for all items except TELEVISION are fetched.
Table: Truth table for AND lists the result of specifying AND between predicates. Table: Truth table for OR lists the
result of specifying OR between predicates. Table: Truth table for NOT lists the result of specifying NOT before the
predicate.
[Table: Truth table for AND]
[Table: Truth table for OR]
86