A condition specifies a combination of one or more expressions and logical (Boolean) operators and returns a value of TRUE, FALSE, or UNKNOWN.

This chapter contains the following sections:

• About SQL Conditions

• Comparison Conditions

• Floating-Point Conditions

• Logical Conditions

• Model Conditions

• Multiset Conditions

• Pattern-matching Conditions

• Null Conditions

• XML Conditions

• SQL For JSON Conditions

• Compound Conditions

• BETWEEN Condition

• EXISTS Condition

• IN Condition

• IS OF type Condition