For the HAVING clause
search-condition::=comparison-predicate[AND
search-condition]
For the WHERE clause
search-condition::={{'('search-condition')'|comparison-predicate}
|NOT{0'('search-condition')'|
comparison-predicate}
|search-conditionOR
{'('search-condition')'|comparison-predicate}
|search-conditionAND
{'('search-condition')'|comparison-predicate}}
Performs the logical operation specified in the search condition and returns only those results for which the condition is true in a relation.
A search condition is specified using the WHERE or HAVING clauses.
comparison-predicate
For details about specifying a comparison predicate, see 4.4.18 Comparison predicate.
Specify a search condition in a WHERE or HAVING clause. The logical operations that can be specified differ depending on the clause. The following table shows the logical operations that can be specified.
Table 4-6 Logical operations that can be specified
No. | Logical operation | WHERE clause | HAVING clause |
---|---|---|---|
1 | AND | Can be specified. | Can be specified. |
2 | NOT | Can be specified. | Cannot be specified. |
3 | OR | Can be specified. | Cannot be specified. |
s1.c1 < 1 OR (s1.c2 < 1 AND NOT (s1.c3 < 3))
s1.c1 < 1 OR (s1.c2 < 1 AND s1.c3 >= 3)
NOT c1>1
NOT(c1>1)
c1>1 AND c2>1
(c1>1) AND (c2>1)
Outputs data in which the value of column a in relation s1 is greater than 1 but less than 5. The underlined part indicates a search condition.
REGISTER QUERY q1 SELECT * FROM s1[ROWS 100] WHERE s1.a < 5 AND s1.a > 1;