Updated on 2023-11-30 GMT+08:00

having_condition

Syntax

Description

Syntax

Description

having_condition

Judgment condition of having.

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.

const_set

Collection of constants, which are separated by using comma (,).

in

Keyword used to determine whether attributes are in the same collection.

attrs_value_set_expr

Collection of attribute values.

attr_expr

Attribute expression.

Equality and inequality

Equation and inequality. For details, see Relational Operators.

pattern_string

Pattern matching string, which supports wildcard matching. In WHERE LIKE, SQL wildcard characters "%" and "_" are supported. "%" represents one or more characters. "_" represents only one character.

like

Relational operator: used for wildcard matching.