where_condition¶
Syntax¶
Description¶
Syntax | Description |
---|---|
where_condition | Judgment condition of where. |
and | Logical operator: AND |
or | Logical operator: OR |
not | Logical operator: NOT |
( | Start of the subjudgment condition. |
) | End of the subjudgment condition. |
condition | Judgment condition. |
exists | Keyword used to determine whether a non-empty collection exists. If exists is followed by a subquery, then the subquery must contain a judgment condition. |
in | Keyword used to determine whether attributes are in the same collection. |
attrs_value_set_expr | Collection of attribute values. |
attr_expr | Attribute expression. |