-
Language:
English
-
Language:
English
Red Hat Training
A Red Hat training course is available for Red Hat JBoss Data Virtualization
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 criteriaExists
represents an EXISTS criteria that determines whether a subquery will return any valuesLike
- represents a LIKE/SIMILAR TO/LIKE_REGEX criteria that compares string values