Este conteúdo não está disponível no idioma selecionado.
B.3. Condition
A criteria is a combination of expressions and operators that evaluates to true, false, or unknown. Criteria are most commonly used in the WHERE or HAVING clauses.
Condition- the base criteria interfaceNot- used to NOT another criteriaAndOr- used to combine other criteria via AND or ORSubqueryComparison- represents a comparison criteria with a subquery including a quantifier such as SOME or ALLComparison- represents a comparison criteria with =, >, <, etc.BaseInCondition- base class for an IN criteriaIn- represents an IN criteria that has a set of expressions for valuesSubqueryIn- represents an IN criteria that uses a subquery to produce the value setIsNull- represents an IS NULL criteriaExistsrepresents an EXISTS criteria that determines whether a subquery will return any valuesLike- represents a LIKE/SIMILAR TO/LIKE_REGEX criteria that compares string values