Updated on 2022-12-07 GMT+08:00

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.