Filter
Top Products
6.2 Specifying Various Search Conditions
Search conditions can be specified in SQL statements to specify the manipulation of rows that satisfy the search
condition. This section explains how to specify search conditions that use a single predicate and predicates combined
by logical operators ("AND", "OR", or "NOT"). The result of a predicate or combined predicate is either "true", "false",
or "undefined". If the result is "true", the search condition is satisfied. If the result is "false" or "undefined", the search
condition is not satisfied.
Specifying logical operators
This section explains the functions of logical operators and how to specify them.
Example 1:
In this example, the logical operator "AND" is specified in the search condition. The rows from the
STOCK table for which ITMNO is 100 or greater and WHCODE is 1 are fetched.
Example 2:
In this example, the logical operator "OR" is specified in the search condition. The rows from the
85